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

On Tue, 28 Aug 2007 13:36:03 -0700, e12762r
wrote:

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.