Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text lookup and return
Hi all,
I have a user form that has a text box, and a list box. I would like the user to be able to type in a name into the text box, press a "find" button and have the corresponding match (or closest to the match) appear as a selection in the list box. I have a sheet ("master list") that contains all of the possible matches/returns to populate the list box. I would have just created a dropdown for selection, however, in some instances the user may not know the exact name and may have to select from the list the closest match to their query. The user form contains a text box, a list box and a "find" button on it. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Text and Receive Other Text in Return | Excel Worksheet Functions | |||
Lookup text in a string with wildcard and return a certain value | Excel Worksheet Functions | |||
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
lookup a text cell and return text | Excel Discussion (Misc queries) | |||
Lookup & return data from ascii text file | Excel Programming |