select cells in dropdown list by keyboard

S

Stacey

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 ?
 
G

Gord Dibben

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
 
S

Stacey

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.
 
S

Stacey

sorry me again, it appears not to work and I have a macro security level
warning appear, the drilldown code didnt work i fear.
 
G

Gord Dibben

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
 
S

Stacey

Hi Gord,

I have downloaded the sample spreadsheet and enable macros and I still am
unable to drilldown !!
 
G

Gord Dibben

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
 
G

Gord Dibben

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
 
Top