Microsoft Office Tutorials and References
In Depth Information
Table 17-4. Command Bar Control Types
Constant
Description
msoControlGenericDropdown
Normal
msoControlGraphicCombo
Combo Box
msoControlGraphicDropdown
Combo Box
msoControlGraphicPopup
Pop-up
msoControlGrid
Normal
msoControlLabel
Normal
msoControlLabelEx
Normal
msoControlOCXDropdown
Combo Box
msoControlPane
Normal
msoControlPopup
Pop-up
msoControlSpinner
Normal
msoControlSplitButtonMRUPopup
Pop-up
msoControlSplitButtonPopup
Pop-up
msoControlSplitDropdown
Combo Box
msoControlSplitExpandingGrid
Normal
msoControlWorkPane
Normal
CommandBarControl Object
CommandBarControl objects represent the individual choices that a user can make. These
choices take the form of command buttons, drop-down lists, combo boxes, and many other
items. Table 17-5 lists the key properties and methods for the CommandBarControl object.
Table 17-5. Key Properties and Methods of the CommandBarControl
Object
Property/Method
Description
BeginGroup
Property: when True , means this control marks the beginning of a
group of controls on a control bar.
BuiltIn
Property (read-only): returns True if the command bar is a part
of Excel.
Caption
Property: contains the text associated with a command bar
control.
Copy (Bar, Before)
Method: creates a copy of the current command bar control to the
specified command bar before the specified control. If Bar is not
specified, the current bar is assumed. If Before is not specified,
the copy will be placed at the end of the command bar.
continued
Search JabSto ::




Custom Search