Properties of command bar controls

Command bar controls have a number of properties that determine how the controls look and work. Following is a list of a few of the more useful properties for command bar controls:

♦ BeginGroup: If True, a separator bar appears before the control.

♦ BuiltIn: Read-only. True if the control is one of Excel's built-in controls.

♦ Caption: The text that is displayed for the control. If the control shows only an image, the caption appears when you move the mouse pointer over the control.

♦ Enabled: If True, the control can be clicked.

♦ FaceID: A number that represents a graphic image displayed next to the control's text, or on the button if the control is a toolbar button.

♦ Id: Read-only. A code number for a built-in control.

♦ OnAction: The name of a VBA procedure to be executed when the user clicks the control.

♦ State: Determines whether a control appears pressed. This property is available only for a CommandBarButton control.

♦ Style: Determines whether the control appears with a caption and/or image. This property is available only for CommandBarButton and CommandBarComboBox controls.

♦ ToolTipText: Text that appears when the user moves the mouse pointer over the control.

♦ Type: An integer that determines the type of the control.

0 0

Post a comment