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

• Microsoft Forms examples
• Microsoft Forms reference
• Microsoft Forms concepts

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.