MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Drop down list (increase size possible)

Posted by Nima on December 03, 2001 8:45 AM

I have a data validation which makes a drop down menu with a bunch of names. However it has around 25 names, but the scroll box only goes to 10 names and then you have to click the down arrow to view the rest of the names. How can i increase the box size.

Many thanks in advance.

Posted by Ted on December 03, 2001 9:50 AM

Change the number in the ListRows property for the box