| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DropdownMenu-how can I use the down arrow to choose my option?
I am trying to create a drop down menu in Excel 2003.
I know how to do that...but I would like to make it so that when someone enters starts to type something that exists in the list it automatically jumps to that option. AND/OR Use the up and down arrow buttons to select the option in the dropdown list. I have seen it done before so I know it can be done- but I just can not figure out how!! Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DropdownMenu-how can I use the down arrow to choose my option?
You can have autocomplete in data validation if you use a combo box -
Debra Dalgleish shows how he http://www.contextures.com/xlDataVal10.html Hope this helps. Pete On Jan 27, 5:31*pm, funkymonty wrote: I am trying to create a drop down menu in Excel 2003. I know how to do that...but I would like to make it so that when someone enters starts to type something that exists in the list it automatically jumps to that option. AND/OR Use the up and down arrow buttons to select the option in the dropdown list. I have seen it done before so I know it can be done- but I just can not figure out how!! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| Using end-arrow down or end-arrow up in a macro | Excel Discussion (Misc queries) | |||
| why dont shift+arrow or ctrl+arrow work in 2007 | Excel Discussion (Misc queries) | |||
| calendar option to choose a date in excel | Excel Discussion (Misc queries) | |||
| How to do the following by pressing the down arrow or up arrow key? | Excel Discussion (Misc queries) | |||
Linear Mode
