DropDownLines Property

Applies To

CommandBarComboBox object.

Description

Returns or sets the number of lines in the specified command bar combo box control. The combo box control must be a custom control and it must be either a drop-down list box or a combo box. Read/write Long.

Note   If this property is set for a combo box control that's either an edit box or a built-in combo box control, an error occurs.

Remarks

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

See Also

Add method (CommandBarControls Collection), AddItem method, Clear method, DropDownWidth property.

Example

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

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