Jump to section in Validation List

M

Metro

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 !
 
B

Bob Umlas, Excel MVP

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