drop down list

[free24]

How do I enter values from a drop down list without using the mouse? I want
to enter a letter or number that corresponds to the first letter or number of
a cell in the validated drop down list, then select that entry without
clicking the mouse.

 

[Squeaky]

How do you intend to select the drop down box?

 

[Gord Dibben]

Data Validation dropdown box?

Autocomplete is not possible.

Using arrow keys to select the DV dropdown then hit Alt + Downarrow.

Using downarrow scroll to your choice and Enter to select.

To have Autocomplete you must use a combobox alone or in conjunction with
the DV dropdown.

See Debra Dalgleish's site for how-to.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

 

[Ashish Mathur]

Hi,

You may want to check Question 44 of the following link -
http://ashishmathur.com/replies.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com