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

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