Gets or sets the width (in pixels) of the list for the specified command bar combo box control. 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.DropDownWidth

expression A variable that represents a CommandBarComboBox object.

Remarks

Note
An error occurs if you attempt to set this property for a built-in control.

If this property is set to -1, the width of the list is based on the length of the longest item in the combo box list. If this property is set to 0, the width of the list is based on the width of the control.

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 "First Item", 1 .AddItem "Second Item", 2 .DropDownLines = 3 .DropDownWidth = 75 .ListHeaderCount = 0 End With
adjust width of a control based on length of longest item in a combo box list change the drop down width of a control DROP drop down width Drop Down Width Property dropdown DropDownWidth dropdownwidth property ofv set the width in pixels of a command bar combo box control

See also: