ListRows property

Specifies the maximum number of rows to display in the list.

Syntax

object.ListRows [= Long ]

The ListRows property syntax has these parts:

Part Description
object Required. A valid object.
Long Optional. An integer indicating the maximum number of rows. The default value is 8.

Remarks

If the number of items in the list exceeds the value of the ListRows property, a scroll bar appears at the right edge of the list box portion of the combo box.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.