Type Ahead within an excel dropdown

D

Daniel

When selecting choices from a dropdown list, is there a way to provide type
ahead (i.e. searches the list based on user's entry in the cell)? Thanks
 
G

Gord Dibben

Daniel

If your drop-down list if from Data Validation, you cannot have Autocomplete.

Try a combo-box drop-down list.

Debra Dalgleish has instructions.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

When selecting choices from a dropdown list, is there a way to provide type
ahead (i.e. searches the list based on user's entry in the cell)? Thanks
Click to expand...

Gord Dibben MS Excel MVP
 

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

Access Backstage Reset DropDowns 0
How to populate other fields when a dropdown was changed 13
Excel does not accept text format! 0
Displaying arrow in a dropdown list within cell 2
Conditional List dropdowns? 1
Need to have a dropdown list or allow other entry? 1
dropdown depending on second dropdown / filter problem 0
how to add a combolist drop down to each row 2

Top