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
.