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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Lists 4
Auto fill not working 2
excel drop down list 4
Quick Find in long drop down list 3
Auto-Completion on Drop-Down Lists 2
Drop down menu formatting 2
Drop down list 4
How can I select an item in a drop down ? 1

Back
Top