If you created the dropdown lists by using data validation, it doesn't
support autocomplete.

If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:

http://www.contextures.com/xlDataVal11.html

Hippy wrote:
were you able to resolve this. I am looking for the same functionality.

"greenfalcon" wrote:


Is there any way to modify this code to show the dropdown box while you
are typing????

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html