| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
select cells in dropdown list by keyboard
when selecting data from my dropdown list, I would like to be able to use
keyboard to cursor to the required cell ... is this possible ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
select cells in dropdown list by keyboard
Usw arrow to keys to navigate to dropdown cell.
Alt + downarrow to open the list. Arrow down to selection and ENTER key. Gord Dibben MS Excel MVP On Mon, 1 Dec 2008 17:19:02 -0800, Stacey wrote: when selecting data from my dropdown list, I would like to be able to use keyboard to cursor to the required cell ... is this possible ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
select cells in dropdown list by keyboard
Hi Thanks for that, however I would like to be able to drilldown by typing
the text, I have a large numeric & text list, and i need to be able to enter a letter to drill down to the appropriate cell. "Gord Dibben" wrote: Usw arrow to keys to navigate to dropdown cell. Alt + downarrow to open the list. Arrow down to selection and ENTER key. Gord Dibben MS Excel MVP On Mon, 1 Dec 2008 17:19:02 -0800, Stacey wrote: when selecting data from my dropdown list, I would like to be able to use keyboard to cursor to the required cell ... is this possible ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
select cells in dropdown list by keyboard
DV dropdown lists do not have Autocomplete capability.
For that feature you would need a Combobox helper. See Debra Dalgleish's site for the how-to part. http://www.contextures.on.ca/xlDataVal10.html Gord On Mon, 1 Dec 2008 18:01:01 -0800, Stacey wrote: Hi Thanks for that, however I would like to be able to drilldown by typing the text, I have a large numeric & text list, and i need to be able to enter a letter to drill down to the appropriate cell. "Gord Dibben" wrote: Usw arrow to keys to navigate to dropdown cell. Alt + downarrow to open the list. Arrow down to selection and ENTER key. Gord Dibben MS Excel MVP On Mon, 1 Dec 2008 17:19:02 -0800, Stacey wrote: when selecting data from my dropdown list, I would like to be able to use keyboard to cursor to the required cell ... is this possible ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
select cells in dropdown list by keyboard
Thanks for your reply
"Gord Dibben" wrote: DV dropdown lists do not have Autocomplete capability. For that feature you would need a Combobox helper. See Debra Dalgleish's site for the how-to part. http://www.contextures.on.ca/xlDataVal10.html Gord On Mon, 1 Dec 2008 18:01:01 -0800, Stacey wrote: Hi Thanks for that, however I would like to be able to drilldown by typing the text, I have a large numeric & text list, and i need to be able to enter a letter to drill down to the appropriate cell. "Gord Dibben" wrote: Usw arrow to keys to navigate to dropdown cell. Alt + downarrow to open the list. Arrow down to selection and ENTER key. Gord Dibben MS Excel MVP On Mon, 1 Dec 2008 17:19:02 -0800, Stacey wrote: when selecting data from my dropdown list, I would like to be able to use keyboard to cursor to the required cell ... is this possible ? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
select cells in dropdown list by keyboard
sorry me again, it appears not to work and I have a macro security level
warning appear, the drilldown code didnt work i fear. "Stacey" wrote: Thanks for your reply "Gord Dibben" wrote: DV dropdown lists do not have Autocomplete capability. For that feature you would need a Combobox helper. See Debra Dalgleish's site for the how-to part. http://www.contextures.on.ca/xlDataVal10.html Gord On Mon, 1 Dec 2008 18:01:01 -0800, Stacey wrote: Hi Thanks for that, however I would like to be able to drilldown by typing the text, I have a large numeric & text list, and i need to be able to enter a letter to drill down to the appropriate cell. "Gord Dibben" wrote: Usw arrow to keys to navigate to dropdown cell. Alt + downarrow to open the list. Arrow down to selection and ENTER key. Gord Dibben MS Excel MVP On Mon, 1 Dec 2008 17:19:02 -0800, Stacey wrote: when selecting data from my dropdown list, I would like to be able to use keyboard to cursor to the required cell ... is this possible ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to keyboard select a row except the last two cells | Excel Discussion (Misc queries) | |||
| Can a Dropdown list change neighoring cells base of what is select | Excel Discussion (Misc queries) | |||
| select dropdown list dependant on value of a given cell | Excel Discussion (Misc queries) | |||
| select multiple items from a dropdown list | Excel Worksheet Functions | |||
| Select chart series using dropdown list | Charts and Charting in Excel | |||
Hybrid Mode
