Hi all,
I have a userform and I'm trying to use VLOOKUP in one of the textboxes to pick up data from a sheet ('Potential'). However, when I run the Userform nothing is happening. I am using the following code:
Any suggestions what I'm doing wrong?
Please Login or Register to view this content.
TIA,
SamuelT
Last edited by SamuelT; 12-11-2008 at 07:48 AM.
Check this out
http://www.freewebs.com/davesexcel/U...rTextBoxes.xls
Last edited by davesexcel; 12-11-2008 at 07:43 AM.
I would use the VBA .Find method.
What is newSheet? If it is the textbox to receive the result then you need to trigger the code
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks for the suggestions guys.
dave - I'll take a look at the link.
Roy - yes, newSheet is the textbox receiving the result. How would one trigger the code?
SamuelT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks