Thread: User Forms and Excel Functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sottsee sottsee is offline
external usenet poster
  
Posts: 1
Default User Forms and Excel Functions

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

Reply With QuoteReply With Quote