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

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

Hi!

Debra Dalgleish has a sample file that demonstrates how to
implement auto-complete in a drop down list:

http://contextures.com/DataValComboboxSheet.xls

Biff

-----Original 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
.

Thanks, Biff. I'm running over to check it out!

*******************
~Anne Troy

www.piersontech.com
www.mrexcel.com


"Biff" wrote in message
...
Hi!

Debra Dalgleish has a sample file that demonstrates how to
implement auto-complete in a drop down list:

http://contextures.com/DataValComboboxSheet.xls

Biff

-----Original 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
.