ControlFormat.DropDownLines Property

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`

Change number of lines in dropdown listbox? DROP drop down lines Drop Down Lines Property dropdown DropDownLines DropDownLines Property Set number of lines displayed in a drop down listbox?

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

See also: