| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Dropdown list key selection
Hi
Is it possible to format a dropdown list in such a way that if you press a letter key while the list is open it will bring to the first entry in the list beginning with that letter? The feature exists with autofilter and the list behind the dropdown is sorted alphabetically |
|
#2
|
|||
|
|||
|
You could use a combobox from the control toolbox toolbar (not from the Forms
toolbar). TrevorM wrote: Hi Is it possible to format a dropdown list in such a way that if you press a letter key while the list is open it will bring to the first entry in the list beginning with that letter? The feature exists with autofilter and the list behind the dropdown is sorted alphabetically -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I import a folder's contents as a dropdown list? | Excel Worksheet Functions | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) | |||
| self-building dropdown list | Excel Worksheet Functions | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Hybrid Mode
