Combobox/textbox problem

I have a ComboBox on a userform that is fed from a named range on another sheet. On that same userform, I ahve a text box.

What I'm trying to do is when I select an option from the combobox, I want the textbox to be coded to do a vlookup to the source sheet.

I know how to do this on a plain sheet but having issues getting it to work on a userform/combobox/textbox format. Any help would be great.

Moved to Office Development forum

Look at the Excel Tips and Tricks in my sig. There you'll find some handy code for the WorksheetFunction object, which will allow you to manipulate all Excel formulae, including the VLookup. Then it's just a case of referencing the sheet and range that you want.

zaza