I am trying to do the following.

I have a list of names in sheet1 column b - b2:B500

I have a user form that I would like to do the following

the user can enter any part of a name into a text box and the list bo
with the names the user can choose will only have those that contai
what he just entered.

for example

a user is trying to find a customers name. The current list box the
can choose from has all names for 500 customers. To make it simpl
there will be a text box that allows them to type in any part of th
customers name and then it will repopulate the list box with th
resulting values of the search term. match case is false....

Thanks for any help...

Jos

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=55159