Gets or sets the number of lines in a command bar combo box control. The combo box control must be a custom control and it must be a drop-down list box or a combo box. Read/write.
Note
The use of CommandBars in some Microsoft Office applications has been superseded by the new Ribbon user interface. For more information, search help for the keyword "Ribbon."

Syntax

expression.DropDownLines

expression A variable that represents a CommandBarComboBox object.

Remarks

Note
An error occurs if you attempt to set this property for a combo box control that's an edit box or a built-in combo box control.

If this property is set to 0 (zero), the number of lines in the control is based on the number of items in the list.

Example
This example adds a combo box control containing two items to the command bar named "Custom". The example also sets the number of line items, the width of the combo box, and an empty default for the combo box.

Visual Basic for Applications 
Set myBar = CommandBars("Custom") Set myControl = myBar.Controls.Add(Type:=msoControlComboBox, Id:=1) With myControl .AddItem Text:="First Item", Index:=1 .AddItem "Second Item", 2 .DropDownLines = 3 .DropDownWidth = 75 .ListHeaderCount = 0 End With
add number of lines to a list box or control DROP drop down lines Drop Down Lines Property dropdown DropDownLines DropDownLines Property ofv return number of lines within a combo box control set the number of lines in a command bar list box

See also: