Freigeben über

CommandBarButton.Execute Method

  • Artikel
Office Developer Reference
Aa432774.vs_note(en-us,office.12).gif  Note
The use of CommandBars in some Microsoft Office applications has been superseded by the new Ribbon user interface. For more information, search help for the keyword "Ribbon."

Runs the procedure or built-in command assigned to the specified CommandBarButton control.

Syntax

expression.Execute

expression   Required. A variable that represents a CommandBarButton object.

Example

This Microsoft Excel example creates a command bar and then adds a built-in command bar button control to it. The button executes the Excel AutoSum function. This example uses the Execute method to total the selected range of cells when the command bar appears.

Visual Basic for Applications 
  Dim cbrCustBar As CommandBar
Dim ctlAutoSum As CommandBarButton
Set cbrCustBar = CommandBars.Add("Custom")
Set ctlAutoSum = cbrCustBar.Controls _
    .Add(msoControlButton, CommandBars("Standard") _
    .Controls("AutoSum").Id)
cbrCustBar.Visible = True 
ctlAutoSum.Execute

See Also