while use enters text in textbox1 I want the textbox to auto compl

[Jim at Eagle]

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

[jotromundo]

I got the same question. Would anyone mind helping us?
Regards.

[royUK]

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.