You cannot. Sorry if this is bad news. You may want to consider moving over
to Access...which does this automatically.

****************
Anne Troy
www.piersontech.com
www.mrexcel.com


"RC" wrote in message
...
I have a program that i have written in exel that has become to large to
manage. i need to be able to select my drop down list and be able to enter
the first character of the item that i trying to find and have excel
return
for me closest match