DV lists won't autocomplete.

You need a combo-box for that.

See Debra Dalglesih's site for instructions.

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




On Mon, 30 Jul 2007 12:02:00 -0700, How to autopopulate a drop down list <How to
autopopulate a drop down wrote:

I have created several drop down lists in Excel by using the Data Validation
Feature.
The problem I am having is that my drop down lists are very long and I would
like the cell to allow a user to just start typing one of the options in the
drop down and have it autopopulate if the option is listed in the drop down.
I already have my settings in Excle to autopopulate, and it does on any other
part of excel, just not the drop down boxes.

Does anyone know how to allow my drop downs to auto populate?
Thanks!!!