Drop Down Box Size

  • Thread starter Thread starter grahammal
  • Start date Start date
G

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.
 
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.
 
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 List 2
Drop-down list and error message 1
Restrict Choice in Shared WB (drop down alternative)? 0
Chart Title change with Drop Down Selection 2
Drop down list from index/match formula 1
Roof Box Recommendations 11
Drop down list hyperlink 4
Drop Down list font too small... help please 4

Back
Top