| 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 ? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
select cells in dropdown list by keyboard
Works as adveryised for me.
When you get the security warning do you enable macros? Go through the steps Debta outlines one more time. Better yet.........download the sample workbook so's you can see it in action. Gord On Wed, 3 Dec 2008 19:21:08 -0800, Stacey wrote: 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 ? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
select cells in dropdown list by keyboard
Hi Gord,
I have downloaded the sample spreadsheet and enable macros and I still am unable to drilldown !! "Gord Dibben" wrote: Works as adveryised for me. When you get the security warning do you enable macros? Go through the steps Debta outlines one more time. Better yet.........download the sample workbook so's you can see it in action. Gord On Wed, 3 Dec 2008 19:21:08 -0800, Stacey wrote: 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 ? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
select cells in dropdown list by keyboard
I can offer no further insights. A couple of question though.
You click on a cell under the Weekday category and type w...........Wednesday should highlight for you to enter. Or in the Month category you click on a cell and type j........Jauary should highlight.............add u and June should highlight. Does this happen for you? Gord On Thu, 4 Dec 2008 18:53:00 -0800, Stacey wrote: Hi Gord, I have downloaded the sample spreadsheet and enable macros and I still am unable to drilldown !! "Gord Dibben" wrote: Works as adveryised for me. When you get the security warning do you enable macros? Go through the steps Debta outlines one more time. Better yet.........download the sample workbook so's you can see it in action. Gord On Wed, 3 Dec 2008 19:21:08 -0800, Stacey wrote: 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 ? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
select cells in dropdown list by keyboard
One more thought.
If you have already selected a value for the dropdown, you will have to delete or backspace that value before you start typing a new value. Gord On Sat, 06 Dec 2008 12:05:24 -0800, Gord Dibben <gorddibbATshawDOTca wrote: I can offer no further insights. A couple of question though. You click on a cell under the Weekday category and type w...........Wednesday should highlight for you to enter. Or in the Month category you click on a cell and type j........Jauary should highlight.............add u and June should highlight. Does this happen for you? Gord On Thu, 4 Dec 2008 18:53:00 -0800, Stacey wrote: Hi Gord, I have downloaded the sample spreadsheet and enable macros and I still am unable to drilldown !! "Gord Dibben" wrote: Works as adveryised for me. When you get the security warning do you enable macros? Go through the steps Debta outlines one more time. Better yet.........download the sample workbook so's you can see it in action. Gord On Wed, 3 Dec 2008 19:21:08 -0800, Stacey wrote: 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 | |||
Linear Mode
