Vlookup doesn't work on my userform

[YFM_eng]

Hi All,

I'm encountering the following problem:

I have a userform with comboboxes and textboxes. What I try to do is when the input of CboTM1 (combobox1) changes, that imput needs to be searched with a Vlookup for the matching data and the output of the vlookup needs to be placed in TB1 (Textbox1).

I have used Vlookup syntax before, but I think I overlooked something. Anyone can help to see if this Vlookup syntax is right?

Please Login or Register  to view this content.

Thanks for any help!

BR Yuri

[dangelor]

What do you mean by "doesn't work"?

[YFM_eng]

Hi Dangelor,

When I Run the code the error is : Unable to get the vlookup property of the worksheetfunction class.

Please Login or Register  to view this content.

That is the line wich is highlited

[dangelor]

That error usually means that it couldn't find a match in the 1st column of your data. If you're sure there is a match to be found. Try removing the DblModNr variable and just use the CboTM1.Value.

[YFM_eng]

Hi Dangelor,

Thanks for your help. I overlooked that the column, in which the function needs to find a match, wasn't column A but column B.

Thanks for your quick reply!

BR Yuri

[dangelor]

Glad I could help!