Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list - goto with keystroke
Hi all,
Can anyone tell me the trick in setting up a dropdown list, using the data validate option, that allows the user to goto a specific point in the list. For example: the list is sorted in alphabetic order and I want the users to be able to go straight to 'P' by keying 'p' instead of having to scroll all the way through the list. Can it be done? Cheers Giz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Update of Dropdown List Box data | Excel Worksheet Functions | |||
How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
HELP! Nesting IF Statements/Dependent Dropdown List | Excel Worksheet Functions | |||
Dropdown list question | Excel Discussion (Misc queries) | |||
Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) |