Drop Down Box Size

[grahammal]

I have several drop down boxes each linked to each other and they work
fine however I need one of them to display more lines than it does at
present. At the moment it displays eight lines of text but I would like
to at least double that. Someone has suggested that you increase the
ListRows setting which would be fine if I could find it in Office 97
Excel. Its not in the Validation settings that I can see.
Can anybody help.

 

[Debra Dalgleish]

In a data validation list, you can't change the number of rows. If you
can use programming, there are instructions here for using a combobox to
overlay a cell with data validation:

http://www.contextures.com/xlDataVal11.html

In the combobox, you can change the ListRows property.