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.)
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…