Selecting from a drop down list
 

I have a drop down list that has approx 120 choices. Is there a way to type
in a letter and have the highlight jump to the first name with that letter?

Example: I want to select the name "Jake"

Can I type in the letter "J" in the drop down list and have it jump to the
nearest name starting with "J"

Thank you for your help in advance!

Selecting from a drop down list
 

Hi,

Please take a look at question 44 of the following link -
http://ashishmathur.com/replies.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Scott W" <Scott wrote in message
...
I have a drop down list that has approx 120 choices. Is there a way to
type
in a letter and have the highlight jump to the first name with that
letter?

Example: I want to select the name "Jake"

Can I type in the letter "J" in the drop down list and have it jump to the
nearest name starting with "J"

Thank you for your help in advance!

Selecting from a drop down list
 

If using a Data Validation List Dropdown, there is no Autocomplete function.

Debra Dalgleish shows how to use a Combobox in conjunction with the DV in
order to enable autocomplete.

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


Gord Dibben MS Excel MVP


On Sun, 28 Dec 2008 14:37:01 -0800, Scott W <Scott
wrote:

I have a drop down list that has approx 120 choices. Is there a way to type
in a letter and have the highlight jump to the first name with that letter?

Example: I want to select the name "Jake"

Can I type in the letter "J" in the drop down list and have it jump to the
nearest name starting with "J"

Thank you for your help in advance!