VBA userform vlookup formula

[Hilton1982]

Hi

I have a userform where i have a combobox which has a drop down list that is coded with a dynamic named range and the user should select one off the numbers.

Next to the combobox i have a textbox which i want the userform to look for the number and return the value of the number?

I'm sure it is possible and it should be on a combobox exit event however i don't know how to do the formula?

Please help?

[Norie]

What exactly have you populated the combobox with?

If it's a contiguous range with unique values then you can use the combobox"s ListIndex property to find the row the selected item is from.

[Hilton1982]

Norie,

Can you help me with a code?

This is what i have in my sheet where the comdbox select the number from and then the text was display in the txtbox
A B
601 Tire Change
602 Re-Torque
603 Pressure
604 Mechanical

[Norie]

It's still not clear how exactly you are populating the combobox.

I know you are using a named range but what is that named range?

Anyway, based on the data you posted this might work.

Please Login or Register  to view this content.

[Hilton1982]

Norie

Sorry for the inconvenience caused the named range is BDCode and that is only for the numbers 601-604

So the text box need to look for the value next to the cell 601-604?

Hope that explains it better

[Norie]

Did you try the code I posted?

[Hilton1982]

Yes I did, and nothing happens when i enter data in the combobox??

[Norie]

Try this.

Please Login or Register  to view this content.