Microsoft Office Tutorials and References
In Depth Information
Table 17-3. Key Properties and Methods of the CommandBarControls
Collection
Property/Method
Description
Add(Type, Id, Parameter,
Before, Temporary)
Method: creates a new command bar object and adds it to the
CommandBarControls collection. Type specifies the general type of
control that should be added. It can be one of the following:
msoControlButton , msoControlEdit , msoControlDropDown ,
msoControlComboBox , or msoControlPopup ; Id is an integer value
that specifies a built-in control. A value of 1 or omitting this
parameter will add a custom control; Parameter contains
programmer-defined information that can be used by the control’s
OnAction routine to determine how to process this instance of the
control; and Before contains the position of the new control in the
collection. If omitted, the control will be added at the end of the
collection; Temporary , when True , means that the control will be
automatically deleted when Excel ends.
Count
Property (read-only): returns the number of CommandBars in the
collection.
Item(Index)
Property: returns the command bar object specified by Index .
Although there are many different types of controls (listed in Table 17-4), they can be loosely
grouped into four major categories: Normal, Button, Combo Box, and Pop-up. Normal con­
trols have all the properties and methods associated with the CommandBarControl object,
whereas Buttons, Combo Boxes, and Pop-ups have additional properties and methods.
Table 17-4. Command Bar Control Types
Constant
Description
msoControlActiveX
Normal
msoControlAutoCompleteCombo
Normal
msoControlButton
Contains a single menu item, an icon button, a
menu item with an icon, or an icon with text below
the image
msoControlButtonDropdown
Combo Box
msoControlButtonPopup
Pop-up
msoControlComboBox
Combo Box
msoControlCustom
Button
msoControlDropdown
Combo Box
msoControlEdit
Combo Box
msoControlExpandingGrid
Normal
msoControlGauge
Normal
Search JabSto ::




Custom Search