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 ?

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 ?

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 ?

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 ?

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 ?

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 ?

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 ?

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 ?

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 ?

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 ?