drop down box

  • Thread starter Thread starter Guest
  • Start date Start date
If your dropdown was created using Data Validation>List you are stuck with 8
visible items and a scroll bar to see more.

See Debra Dalgleish's site for working with combo-boxes that allow more visible
items along with other neat features such as autocomplete.

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






How do I have more than 8 articles in my drop down box
Click to expand...

Gord Dibben MS Excel MVP
 
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 with dynamic named range offsheet source list 14
Formatted cell column in drop down list 1
drop down box code 2
customize drop-down box 1
Odd Drop Down Box Behavior 4
Protecting Sheets with drop down boxes 1
Drop Down list predicated on other drop down lists 2
How do you select multiple characters in a drop down list to appe. 2

Back
Top