PDA

View Full Version : Vlookup Or Find With Textbox On Another Workbook



dgraham62
12-30-2007, 03:31 PM
Hi,

I have a user form with 3 textboxes, I'd like the data from a master workbook (Drivers.xls) to be looked up when a user enters an employees work id in textbox1 and have textbox2 and textbox3 populated with the employees first and last names, then further data will be added to other textboxes and the current workbook (Lockers.xls) will be updated with the user form data.

Thanks for any assistance

Regards

David

stanleydgrom
12-30-2007, 07:27 PM
David,

See the answer your post on Ozgrid:
http://www.ozgrid.com/forum/showthread.php?t=82251


Have a great day,
Stan

Aussiebear
12-31-2007, 03:27 AM
David, You indicated on the other site that you agreed to a set of rules, in fact its typed in there under your log on name.... Those rules include
CROSS POSTING

If you MUST post the same question to multiple (http://www.ozgrid.com/forum/autolink.php?id=36&script=announcement&forumid=8) forums/newsgroups the least you can do is supply a link (http://www.ozgrid.com/forum/autolink.php?id=57&script=announcement&forumid=8) to the others. Same applies to the other forums/newsgroups, that is, link back to your thread on the Ozgrid forum.

WHY? Nothing annoys those who kindly offer FREE help more than finding out they have wasted their time helping you, only to find out the question has been solved elsewhere, or they are suggesting something already suggested & rejected elsewhere.

What makes you think its any different here? If you can't show the people on this forum some respect, then maybe you need to post your questions somewhere else on a full time basis.