Page 399 - Microsoft Office Excel 2003 Programming Inside Out

Part 5: Manipulating Excel Objects
Command Bars

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. Chapter 17
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

373