Type Ahead within an excel dropdown
 

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

Type Ahead within an excel dropdown
 

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

On Thu, 16 Nov 2006 11:07:01 -0800, Daniel
wrote:

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

Gord Dibben MS Excel MVP