MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Drop Downs

Posted by Phil S. on January 02, 2001 6:51 PM

Is there a way get get Data Validation Drop Down Boxes in Excel 97 to display more than 8 entries? I've got 12 entries in my list and would like to be able to get at them all without having to scroll the Drop Down.

Posted by Dave on January 02, 2001 9:08 PM

Hi Phil

Sorry to say, but I would say not. Unforunately this is hard coded into Excel.

You could do this with a Combobox from the Control toolbox though, but it would require VBA to apply the validation or a combinaton of both VBA and Data Validation. No big deal though probably just a Select Case statement.


  • OzGrid Business Applications

Posted by Rickey Bowers Jr. on January 03, 2001 1:59 PM

Change the ListRows property

Have a nice day, Rickey

Posted by Dave on January 03, 2001 11:51 PM

Hi Rick

Phil is asking about Data Validation. :O)

  • OzGrid Business Applications