rodich
03-31-2010, 10:51 PM
Hi, all
I have some drop down list. In the list I view only 8 rows. How I can view 24 rows, for example
I have some drop down list. In the list I view only 8 rows. How I can view 24 rows, for example
|
View Full Version : data validation, how can view more rows in list rodich 03-31-2010, 10:51 PM Hi, all I have some drop down list. In the list I view only 8 rows. How I can view 24 rows, for example HiTechCoach 03-31-2010, 10:57 PM Try setting the List Rows property for the combo box. chergh 04-01-2010, 12:05 AM Try setting the List Rows property for the combo box. he's using a data validation drop down not a combo box. In answer to the OP's question; you can't change the number of items displayed by the data validation drop down. See http://www.contextures.com/xlDataVal11.html for a workaround. rodich 04-01-2010, 12:25 AM Thank you , gays! I'll try! Happy Easter! HiTechCoach 04-01-2010, 08:06 AM I missed seeing that this was about Ecxel. My answer was for Access. |