Select item from Excel drop-down list by pressing letter key
Posted on 2010-09-12
I have set up a drop-down list in Excel, using data validation to a list (named range).
How can I set up the list so that a user can press a letter key (or a sequence of keys) to bring the highlighted entry in the list to the first entry in the list beginning with the selected letter (or letters)? This is standard behaviour in many other programs (including Autofilter in Excel 2003).
We are currently moving from Excel 2002/2003 to Excel 2010, so please specify if your response only works in certain versions of Excel.
(Please note: I know that it is possible to have a similar result using combo-boxes, but at this stage I do not want to convert my spreadsheets to using ActiveX/controls.)
Thanks for your help.