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


--
greenfalcon
------------------------------------------------------------------------
greenfalcon's Profile: http://www.excelforum.com/member.php...o&userid=13622
View this thread: http://www.excelforum.com/showthread...hreadid=466982

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