Drop Down Lists

[e12762r]

How can I select from my Drop Down lists by starting to type in the word?
For example, when I type in 'G', the names in the list beginning with 'G'
will be selectable, when I add 'a'; I should be getting closer to selecting
'Gate' - for instance.

 

[Gord Dibben]

Assuming you are speaking of DV dropdown lists, you cannot have autocomplete.

Use a ComboBox for that.

See Debra Dalgleish's site for more.

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


Gord Dibben MS Excel MVP