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!

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!

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!