ExcelBanter - drop down box

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - drop down box (https://www.excelbanter.com/excel-worksheet-functions/117234-drop-down-box.html)

Gilbo

drop down box

How do I have more than 8 articles in my drop down box

Gord Dibben

drop down box

If your dropdown was created using Data ValidationList 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

On Thu, 2 Nov 2006 09:28:01 -0800, Gilbo
wrote:

How do I have more than 8 articles in my drop down box

Gord Dibben MS Excel MVP

All times are GMT +1. The time now is 08:26 AM.