Search results for query: *

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...

Rob, the loop works great until it reaches a cell where my salesperson types in &quot;Nothing this month&quot;. This were I get the error. I can always use On Err Resume Next, however, I would like to eventually delete the text in the cell.. I don't know how to deal with both Text and Numbers...

Hi. Running into a Type Mismatch error when running the loop below. I receive a rather large spreadsheet (up 9000 rows on certain months) monthly and I need to highlight certain amounts. Problem lies in that some of the cells have text in lieu of numbers. I just want the Sub to ignore the...

Mike, Cell(1,&quot;C&quot;).value=100 Cell(2,&quot;C&quot;).value=525 Cell(3,&quot;C&quot;).value=&quot;Nothing to report&quot; Cell(4,&quot;C&quot;).value=1500 . . Cell(8524, &quot;C&quot;).value=&quot;Nothing&quot; Row.count can be as high as 9100 and I need a loop to convert the text string...

I'm going to be dealing with a rather large spreadsheet monthly (8000+rows). Cells in column &quot;C&quot; have both numbers and text strings. I need to convert the text strings to ZERO. I can't find the correct sytax for the If Then Loop to make the change. I keep getting a Type Mismatch...

Hope the following is clear. I've got a combobox with a sub-form on my main form. As I choose the item from the combobox, the sub-form shows the information for that item. I need to have the &quot;Not in list&quot; property enabled for the combobox. I have no problem with the code to add...