Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox to lookup part text any help pls
i have a database that will store peoples names in column b is there a code to launch a message box on worksheet open that will have an area to type in client name and a find button, not an exacty match but a match such as "jo" would match jo from the name john but have a button to find next, once found select cell and close msgbox i have never used msgbox features before and have limited knowledge of the match or vlookup functions so any help would be apprechiated thanks -- short_n_curly ------------------------------------------------------------------------ short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576 View this thread: http://www.excelforum.com/showthread...hreadid=389484 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox to lookup part text any help pls
Better - use a Userform with a ComboBox showing all the names in column B.
Than as you type it will progress down the list. You can use scrolling or typing to get to the name you want. Than use the ComboBox.ListIndex + 1 to go to that row. -- steveB Remove "AYN" from email to respond "short_n_curly" wrote in message news:short_n_curly.1slaae_1122066349.9444@excelfor um-nospam.com... i have a database that will store peoples names in column b is there a code to launch a message box on worksheet open that will have an area to type in client name and a find button, not an exacty match but a match such as "jo" would match jo from the name john but have a button to find next, once found select cell and close msgbox i have never used msgbox features before and have limited knowledge of the match or vlookup functions so any help would be apprechiated thanks -- short_n_curly ------------------------------------------------------------------------ short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576 View this thread: http://www.excelforum.com/showthread...hreadid=389484 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 part lookup question | Excel Worksheet Functions | |||
Lookup Using Part of a Text | Excel Worksheet Functions | |||
Multi Part Lookup | Excel Discussion (Misc queries) | |||
2-part LOOKUP...t'were it possible? | Excel Discussion (Misc queries) | |||
Part Number Lookup | Excel Worksheet Functions |