drop down menu autocomplete

[Olivo]

Excel 2003. drop down menu
how do i turn on the automatic feature that recognizes what i'm going to
type....type an "e" and everything starting with e drops below the menu box?

 

[Roger Govier]

Hi Olivo

Using Data Validation in Excel, you can't. You would need to use a Combo
Box.

I have written some code to aid navigation to all entries beginning with a
letter, using Data Validation.
There is an example file you can download at Debra Dalgleish's site

http://www.contextures.com/DataValHeadings.zip

Also, at Debra's site, you can find information on how to set up and Combo
Boxes instead
http://www.contextures.com/xlDataVal10.html