View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.setup
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default How do I set a drop-down to auto-pop. by typing first letter?

Hi

You can't have autocomplete with DV, but there is a method of typing a
letter and jumping to that letter in a list.
I have an example file with code that can be downloaded from Debra
Dalgleish's site
http://www.contextures.on.ca/DataValHeadings.zip

--
Regards
Roger Govier



"Jeniam" wrote in message
...
Set up a drop-down, but want to be able to type a letter to send it to the
first letter in the drop-down list. For example, if you had a list of
states, and you hit the "W" key, it takes it to "Washington"