ExcelBanter - Jump to section in Validation List

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Jump to section in Validation List (https://www.excelbanter.com/excel-programming/289859-jump-section-validation-list.html)

Metro

Jump to section in Validation List

I have a cell with Validation that displays a List with 1000 entries in it. How can I make it so that when the user types an 'h', it jumps to the first entry in the List that starts with an 'h' so the user doesn't have to scroll all the way down to the h's ?

Thanks in advance !

Bob Umlas, Excel MVP[_2_]

Jump to section in Validation List

Sorry, that's not possible in a data validation list. (a list of this type is frequently not a sorted list)

All times are GMT +1. The time now is 07:13 PM.