Recent content by MuskyMan

Requesting help for this rookie! Having run-time error after the loop, can't seem to get the syntax or I'm missing something. Thanks for the help.. Private Sub CommandButton1_Click() For i = 1 To 110 Sheet2.Cells(i, 1) = i Next i...

Need ComboBox1.value in Form1 to go TextBox2 in Form2 when Combobox1.afterupdate. Form2 is not opened. Can't seen to get the code correctly. Thanks for the help

I don't have the code written out however, I can tell you that the loop will look at the second column of the row and delete the row if this cell is empty. if cell(r,2)=empty then delete the row. Thanks

I've got to go through a rather large workbook and delete certain rows. I can come up with loop but can't come up with the code to delete the row once the loop has found it. Thanks in advance for the reply.

Need to show a field in my form from another table. Having a major memory lapse... Thanks in advance..

Having "Compile error sub or function not defined" when running the code below. For sakes of space, I've just pasted the problem area.. Do While Cells(r, 1) <> Empty Cells(r, 9).Value = Mid(Cells(r, 1), 20, 11) Cells(r, 10).Value = VLookup(Cells(r, 9).Value, ElecBud, 4) r = r + 1 Loop I'm not...

I need to clean it up a spreadsheet. One issue I'm having is 1,800 cells with text. Sample of the text: ' C5545544-Taxes ' M133rt-Closed ' 455123-CAM charges I need to strip the ' and spaces. I've trid MID but with different number of spaces it's a pain. Any thoughts on what to...

Is there a way to synchronize the active cell as you move from worksheet to worksheet in a workbook? Example: sheet1, cell position a1 as I go to sheet2 I want the active cell to be a1 Thanks for the help!

I've connected a desktop (running win98) and a laptop (running xp)with the cat5 netwrk cable. I can access the desktop PC and its printer via the laptop but not vice-versa. I've checked all the normal stuff, file sharing, etc. Any idea what's missing. Thanks

Thank YOU!!! I can sleep tonight.....

Hope the following is clear.. My form has a combobox (Account) that is getting data from a table with 2 fields (Account and Catagory). On this same form I need to display the corresponding Catagory after using the combobox. Can't seem to display the Catagory using an unbound control on the...

I have a user form that opens up upon a document being opened. I've got 3 textboxes and a command button in the Form. I would like the command button to insert in my document the variables from the textboxes. I can't find an example that would show me the code for this.. Thanks

Hey cghoga, thanks! The code worked like I had hoped. I could not open up my CAD (dwg) file but luckly I can convert these to a BMP. Thanks again..

Each record has a coresponding image file. I've linked the Object to the record using the wizard without any problems, however, I need to double-clik to show the object (either a JPG or a DWG file). Is there a way that the object opens automatically without having to double-click? Thanks...

Thanks Rob and PHV, IsNumeric was the last step that I was looking for...