Userform lookup Help

[Rabble]

I am creating a userform that I hope to use to create a quick quotation packagei have worked out most of the userform and it now works fine i just have one small thing that i need help with
The userform that i have created has a combobox which is used to show part numbers from my spreadsheet. I would now like to add a text box that will display the part discription when the combobox part number is selected.
I have been told that the lookup function is the best way to achive this.
I have no problem with the lookup function in my worksheets but adding it to the userform is causing me real problems.
Is this the best way to do what i am trying to do?
I am new to using vba and am struggleing to create the code to make this work. Any help would be gratefully recieved.
Rabble

 

[DiscoPistol]

Hi,

You need to use application.vlookup (which is basically a Vlookup!)

It should look something like this

found = Application.Vlookup(lookFor.Value, rng, col, 0)

DP