User Forms and Excel Functions

[sottsee]

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.

[STEVE BELL]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>