April 2006
Beginner
1114 pages
98h 16m
English
commandbarcombobox.Clear( )
Removes all the items from the list. The following code removes the items added in the preceding AddDropDown procedure:
Sub RemoveAll( )
Dim cbo As CommandBarComboBox, i As Integer
' Get the control
Set cbo = CommandBars("Worksheet Menu Bar").FindControl _
(msoControlDropdown, , "cboSelectText", , True)
' Remove the items.
cbo.Clear
End SubRead now
Unlock full access