How do I have more than 8 articles in my drop down box
G Gord Dibben Nov 2, 2006 #2 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
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
