I built a spreadsheet using the VLOOKUP function. I enter the search string into the chosen cell and then a table is searched and the matching string is returned. This is all done directly from the worksheet.

How can I do the same thing from a field on a user form? How do I reference a function like VLOOKUP?

I've been around programming for a while but just recently discovered VBA for Excel.