Auto-complete an entry in drop-down list

[Guest]

In Excel 2003, I need to be able to auto-complete an entry in a drop-down
list. I have set up a drop-down list that includes over 1000 entries. I would
like to be able to type the first letter or two and get a list of available
options from the list that includes those first few letters.

 

[Debra Dalgleish]

If you created the dropdown list through 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

 

[Guest]

Thank you for your response. I was afraid my answer would include some
programming.