You need a combobox to get the autocomplete function. DV doesn't have it.

See Debra Dalglesih's site for how-to and code.

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


Gord Dibben MS Excel MVP

On Mon, 8 Dec 2008 09:24:01 -0800, John V wrote:

Suppose I have a cell with month names for choices. In asimilar HTML input
page, the user would type "J" and "January" appears. Type "J" again and
"June" appears. A third time and "July" appears.

The typical excel drop-down (data validation) allows the user to type "Jan"
in the cell, but will not choose "January." And the cell won't function as
described in the first paragraph.

I would like the cell to behave more like the HTML code. Is what I'm
describing doable in Excel? How? Many thanks, John