Share via

ControlFormat.DropDownLines Property

  • Article
Excel Developer Reference

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.

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

See Also