April 2006
Beginner
1114 pages
98h 16m
English
commandbarcombobox.ListHeaderCount [= setting]
Sets or returns the position of a separator bar in the drop-down list. For example, the following code adds a separator bar after the third item in the list created earlier:
Sub AddDropDownListSeparatorBar( )
Dim cbo As CommandBarComboBox
' Get the control
Set cbo = CommandBars("Worksheet Menu Bar").FindControl _
(msoControlDropdown, , "cboSelectText", , True)
cbo.ListHeaderCount = 3
End SubRead now
Unlock full access