CommandBarComboBox.ListHeaderCount property (Office)
Gets or sets the number of list items in a CommandBarComboBox control that appears above the separator line. Read/write.
The use of CommandBars in some Microsoft Office applications has been superseded by the new ribbon component of the Microsoft Office Fluent user interface. For more information, see Overview of the Office Fluent ribbon.
expression A variable that represents a CommandBarComboBox object.
This property is read-only for built-in combo box controls.
A ListHeaderCount property value of - 1 indicates that there's no separator line in the combo box control.
This example adds a combo box control to the command bar named Custom and then adds two items to the combo box. The example uses the ListHeaderCount property to display a separator line between First Item and Second Item in the combo box. 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) With myControl .AddItem Text:="First Item", Index:=1 .AddItem Text:="Second Item", Index:=2 .DropDownLines = 3 .DropDownWidth = 75 .ListHeaderCount = 1 End With
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.