Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
ms excel
Name: chai mf Date: June 12, 2003 at 22:34:19 Pacific OS: win95 CPU/Ram: 300/128
Comment:
what is wrong with the macro below:
Private Sub ComboBox1_Change() TextBox2.Text = Application.WorksheetFunction.VLookup(ComboBox1.Text, sheet2!b:c, 2, False)
Name: A Certain TH Date: June 14, 2003 at 14:36:02 Pacific
Reply:
Several Things.
The most obvious is the range. VBA does not recognise Excel ranges in their "spreadsheet" form. "sheet2!b:c" means "a bunch of alphanumeric characters" to the VBA compiler. ie. Specify your range in RANGE style: Sheets("Sheet2").Range("B:C")
So your expression should be: Application.WorksheetFunction.VLookup(ComboBox1.Text, Sheets("Sheet2").Range("B:C"), 2, False)
Cheers Tom
0
Response Number 2
Name: chai Date: June 14, 2003 at 17:39:37 Pacific
Summary: In an MS Excel document, I have a PDF link that I have no problem to open anywhere else. But on my computer, when I open that link, it opens Adobe and closes it right away (the document never opens......
Summary: I know how to use an IF statement to change the value of a cell in MS Excel (Office XP). But can the color of the text be changed also? Or the background fill? ...
Summary: I want to restrict number of digit in a selected column in a sheet of MS Excel 2003. Example: I want that on a cell I will type only 123 but not 1234. Can anyone give me a solution ASAP. Thanks in adv...
0 
