select cells in dropdown list by keyboard

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

 

[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

 

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

 

[Gord Dibben]

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

 

[Stacey]

Thanks for your reply

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

 

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

 

[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

 

[Stacey]

Hi Gord,

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

 

[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

 

[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