Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kwally11 kwally11 is offline
external usenet poster
 
Posts: 1
Default Data Validation

Hello, does anybody know how to create a data validation cell that would go
directly to a word in that list once a letter was pressed? For example, if
you had a list created with apple, banana, grape and lemon, if you tab to
that cell and press a, then apple would come up as opposed to having to click
the drop down and click on apple?