how do I make drop-down list select based on 1st letter entered?

[Missykender]

I want to create a drop-down list that will automatically highlight the
correct selection when the user enters the first letter of the line. For
example, 'N' would highlight 'Next Day AM', 'S' automatically highlight
'Second Day', and so on, without user having to drag his mouse down to
select.

Thanks in advance!

 

[PCLIVE]

If you are familiar with the Combo Box, then you can use that and it is
already setup to do this. Combo Box is from the Control Toolbox toobar.

 

[Gord Dibben]

Missy

DV drop-downs are not capable of providing autocomplete.

For workaround using a combo-box see Debra Dalgleish's site.

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


Gord Dibben Excel MVP

 

[Chris Lavender]

.... but by default the MatchEntry property is fmMatchEntryComplete (at least
on my version of XL!). You need to change the property to
fmMatchEntryFirstLetter

Best rgds
Chris Lav