Thread: Type Ahead within an excel dropdown
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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
Reply With QuoteReply With Quote