Selecting from a drop down list

  • Thread starter Thread starter Scott W
  • Start date Start date
S

Scott W

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop down list 3
Dependent drop down dynamic range formula, off sheet. 7
Making drop down selection lists 2
Drop Down with dynamic named range offsheet source list 14
Formatted cell column in drop down list 1
Data Validation drop-down width, with named range source (XL03 and 4
25#Data Validation 4
Excel 2007 drop down lists 6

Back
Top