| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a drop down list -- Autojump to first letter
I have a spreadsheet with many many drop-down lists. Is there any wa for a user to enter the first letter of an option and automaticall jump to that option in the list? The goal is to make this faster to use than (or at least as fast as writing it out, and right now, clicking on, scrolling through, an selecting from each drop-down is a lengthy process -- Siobhan ----------------------------------------------------------------------- Siobhank's Profile: http://www.excelforum.com/member.php...fo&userid=2613 View this thread: http://www.excelforum.com/showthread.php?threadid=39461 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a drop down list -- Autojump to first letter
Not supported in data validation dropdowns.
-- Regards, Tom Ogilvy "Siobhank" wrote in message ... I have a spreadsheet with many many drop-down lists. Is there any way for a user to enter the first letter of an option and automatically jump to that option in the list? The goal is to make this faster to use than (or at least as fast as) writing it out, and right now, clicking on, scrolling through, and selecting from each drop-down is a lengthy process. -- Siobhank ------------------------------------------------------------------------ Siobhank's Profile: http://www.excelforum.com/member.php...o&userid=26133 View this thread: http://www.excelforum.com/showthread...hreadid=394612 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a drop down list -- Autojump to first letter
Gotcha. I found out it has to be a combobox from the control toolbar. Once I have a combobox from the control toolbar, how do I enter my list values? How do I set matchentry? -- Siobhank ------------------------------------------------------------------------ Siobhank's Profile: http://www.excelforum.com/member.php...o&userid=26133 View this thread: http://www.excelforum.com/showthread...hreadid=394612 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I set a drop down list to scroll to a letter by typing it? | Setting up and Configuration of Excel | |||
| How do I set up a drop down list to beginning letter of item? | Excel Discussion (Misc queries) | |||
| how do I make drop-down list select based on 1st letter entered? | Excel Discussion (Misc queries) | |||
| Using a drop down list -- Autojump to first letter | Excel Discussion (Misc queries) | |||
| press letter and go 2 entry begin w letter in data validation drop | Excel Programming | |||
Linear Mode
