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!

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.


"Missykender" wrote in message
...
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!

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

On Thu, 6 Oct 2005 13:49:03 -0700, "Missykender"
wrote:

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!

.... 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


"PCLIVE" wrote in message
...
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.


"Missykender" wrote in message
...
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!