B
Bimal
Hi guys,
I was using vlookup in a combobox.click event to populate the text box
as per the value of combobox. I came across a rather strange behaviour
of VBA.
The problem line is
Txcon.Value = Application.WorksheetFunction.Vlookup(ComboBox1.Value,
Sheets("Out").Range("B:M"), 6, False)
Txcon is textbox. This gives run-time error 1004 "Unable to get the
vlookup property of the worksheetfunction class".
However the same line works fine if I change the sheet name from "Out"
to "In"
I cant belive there is my mistake coz it works properly if change the
sheet name.
Is this a bug or something else?
Hope some expert can answer me.
Bimal.
I was using vlookup in a combobox.click event to populate the text box
as per the value of combobox. I came across a rather strange behaviour
of VBA.
The problem line is
Txcon.Value = Application.WorksheetFunction.Vlookup(ComboBox1.Value,
Sheets("Out").Range("B:M"), 6, False)
Txcon is textbox. This gives run-time error 1004 "Unable to get the
vlookup property of the worksheetfunction class".
However the same line works fine if I change the sheet name from "Out"
to "In"
I cant belive there is my mistake coz it works properly if change the
sheet name.
Is this a bug or something else?
Hope some expert can answer me.
Bimal.