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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StacieKTU - 22 Nov 2005 20:45 GMT

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?

Reply to this Message

Gord Dibben - 22 Nov 2005 22:34 GMT

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

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

Reply to this Message

StacieKTU - 23 Nov 2005 14:48 GMT

Thank you so much!

> Data Validation drop-downs do not allow for autocomplete.
>
[quoted text clipped - 9 lines]
> >begin typing and have it find the first match and then select with the mouse
> >the right one?

Reply to this Message