Auto-complete an entry in drop-down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top