Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Jump when copying a list of cells | Excel Discussion (Misc queries) | |||
custom section of filter list? | Excel Discussion (Misc queries) | |||
Validation 'Jump To' | Excel Worksheet Functions | |||
How can you jump to a selection in a validation drop-down? | Excel Worksheet Functions | |||
Quick Jump to end of list... | Excel Worksheet Functions |