DV dropdowns do not have autocomplete capability.

See Debra Dalgleish's site for combining DV with a ComboBox.

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


Gord Dibben MS Excel MVP

On Tue, 24 Nov 2009 13:34:02 -0800, bettyh
wrote:

I have a drop down list, I want it to select the choice when the first letter
is typed in. How can I do that?
I just need the dropdown to ensure there are no typos in the answer.