ControlFormat.DropDownLines property (Excel)

Returns or sets the number of list lines displayed in the drop-down portion of a combo box. Read/write Long.

Syntax

expression.DropDownLines

expression A variable that represents a ControlFormat object.

Example

This example creates a combo box with 10 list lines.

With Worksheets(1).Shapes.AddFormControl(xlDropDown, _ 
 Left:=10, Top:=10, Width:=100, Height:=10) 
 .ControlFormat.DropDownLines = 10 
End With

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.