msgbox to lookup part text any help pls

[short_n_curly]

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

[STEVE BELL]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>