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.


--
sottsee
------------------------------------------------------------------------
sottsee's Profile: http://www.excelforum.com/member.php...o&userid=25243
View this thread: http://www.excelforum.com/showthread...hreadid=387345

In your code just set a variable to
x = WorksheetFunction.Vlookup(VALUE,Range("E35:L47"),2 ,TRUE)
but qualify where the ranges and values are coming from.

--
steveB

Remove "AYN" from email to respond
"sottsee" wrote in
message ...

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.


--
sottsee
------------------------------------------------------------------------
sottsee's Profile:
http://www.excelforum.com/member.php...o&userid=25243
View this thread: http://www.excelforum.com/showthread...hreadid=387345