Can Drop Down Boxes jump to the answer as you type?

If I create a form with VBA, to create a drop down box to have a list to pick
an answer for to fill in a cell in a worksheet, it will jump to the answer in
the list as you type. Can a Data|Validation|List do the same thing? If not,
is there a way to get that functionality in Excel?

Data Validation doesn't support autocomplete.

If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:

http://www.contextures.com/xlDataVal11.html

rrucksdashel wrote:
> If I create a form with VBA, to create a drop down box to have a list to pick
> an answer for to fill in a cell in a worksheet, it will jump to the answer in
> the list as you type. Can a Data|Validation|List do the same thing? If not,
> is there a way to get that functionality in Excel?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Is there any way to modify this code to show the dropdown box while you are typing????

were you able to resolve this. I am looking for the same functionality.

"greenfalcon" wrote:

>
> Is there any way to modify this code to show the dropdown box while you
> are typing????
>
>
> --
> greenfalcon
> ------------------------------------------------------------------------
> greenfalcon's Profile: http://www.excelforum.com/member.php...o&userid=13622
> View this thread: http://www.excelforum.com/showthread...hreadid=466982
>
>

If you created the dropdown lists by using data validation, it doesn't
support autocomplete.

If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:

http://www.contextures.com/xlDataVal11.html

Hippy wrote:
> were you able to resolve this. I am looking for the same functionality.
>
> "greenfalcon" wrote:
>
>
>>Is there any way to modify this code to show the dropdown box while you
>>are typing????

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html