Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
while use enters text in textbox1 I want the textbox to auto compl
As a user enters a name in textbox on userform1, I want the textbox to
complete the entry upon finding a unique match in Vlookup table on sheet3. If no match found then user can continue entry of name and address and after selecting commandbutton1 the info is added to vlookup table and then sorted. Exp: After entering "B" and then "o" the textbox will complete with "Bob the the hat Corp" and complete the other textboxes with address, phone # and such. Then user can select Comandbutton2 which places that client into spreadsheet cells and exits userform1. -- Jim at Eagle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TextBox1 to Label4 | Excel Discussion (Misc queries) | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
Web Query running in backg. -how to know when data retrieval compl | Excel Programming | |||
x = textbox1.value (somethings wrong) | Excel Programming | |||
Auto updates of textbox | Excel Programming |