press letter and go 2 entry begin w letter in data validation drop
 

How can I get Excel's data validation dropdown to act list a regular listbox
dropdown, i.e., when I press a letter, the first item that begins with that
letter is highlighted in the list?

Thanks

press letter and go 2 entry begin w letter in data validation drop
 

Data Validation drop down lists don't support that.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"MCP" wrote in message
...
How can I get Excel's data validation dropdown to act list a
regular listbox
dropdown, i.e., when I press a letter, the first item that
begins with that
letter is highlighted in the list?

Thanks