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?