Drop Down List Autofill

  • Thread starter Thread starter Guest
  • Start date Start date
If you created the dropdown list through Data Validation, it doesn't
support autocomplete (if that's what you mean by autofill).

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

Back
Top