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

Not in data validation, but you could use an activeX control

--

Regards,
Nigel




"John V" wrote in message
...
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

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