• 0

Excel validation drop down menu question


Question

Is there a way, in Excel 2007, to make it where you create a named list, and then make a validation table with a drop down menu which refers to that list that (the main point) you can hit a letter and it'll jump to that spot in the drop down menu?

An example would be, if you have a list of the months of the year, I can make it where if I type 'N' it will auto-complete November, but if I type 'J' and click the drop down arrow, it gives an error. If I type 'Ja' it will auto-complete January, but the drop down arrow will still give an error.

I know auto-complete works on the string of letters and fills in when you get a unique string, but I just want to be able to type a letter or two in the field, and then hit the drop down arrow and have it jump to the first word starting with that letter.

For instance, if I type 'Ju' in the field, I want the drop down menu to start at 'June' where if I need I can select June or July. (or anything else if I scroll.)

Is that possible? It's driving me bonkers.

Thanks!

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

you need to use a combobox, not a data validation box (on the developer tab)

google that, and then on the settings of your combo box there should be a button to enable autocomplete

Link to comment
Share on other sites

  • 0
you need to use a combobox, not a data validation box (on the developer tab)

google that, and then on the settings of your combo box there should be a button to enable autocomplete

cool, I'll look into that. thanks!

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.