Drop Down List a la HTML

J

John V

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Pick from drop-down list gives empty or erroneous result 6
Drop Down List Dependant Formula 2
Conditional Validation In Excel 1
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Drop down-list translation 2
Use word to associate an item in validation drop down list 2

Top