data validation, how can view more rows in list

[rodich]

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]

Try setting the List Rows property for the combo box.

 

[chergh]

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]

Thank you , gays! I'll try!
Happy Easter!

 

[HiTechCoach]

I missed seeing that this was about Ecxel. My answer was for Access.