How do I select form a drop down box by typing the first part?

[StacieKTU]

I have created a drop down box with many entries in it. Is there a way I can
begin typing and have it find the first match and then select with the mouse
the right one?

 

[Gord Dibben]

Data Validation drop-downs do not allow for autocomplete.

To get that feature you need a combo-box.

Debra Dalgleish has done the work for you.

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


Gord Dibben Excel MVP

 

[StacieKTU]

Thank you so much!

Data Validation drop-downs do not allow for autocomplete.

To get that feature you need a combo-box.

Debra Dalgleish has done the work for you.

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


Gord Dibben Excel MVP