Question

how to increase no of rows of validation list (drop down list)???

DropDownList, Microsoft Excel, Excel macros

hello,
thanks for viewing this thread.
i have one excel sheet. i have entered following data in 30 rows in one column and created the validation list for that data
10:00 AM
10:01 AM
10:02 AM
''
''
'
''
5:00 PM
i want to show drop down list box with my own no of rows to be displayed not current validation's list box's default 8.
you can suggest macro for that

thanks
abhijeet

I was pretty sure that the size of the dropdown can never exceed 8. It's the same select element used by IE in HTML and it does the same thing there.

I found some validation for this and a quick workaround here: http://www.contextures.com/xlDataVal08.html#Wider

In the section Data Validation Font Size and List Length they recommend a combo box overlay in code to simulate a larger dropdown length:

"The font size in a data validation list can't be changed, nor can its default list length, which has a maximum of eight rows.

If you reduce the zoom setting on a worksheet, it can be almost impossible to read the items in the dropdown list, as in the example at right.

One workaround is to use programming, and a combo box from the Control Toolbox, to overlay the cell with data validation. If the user double-clicks on a data validation cell, the combobox appears, and they can choose from it."