Occurs when a user presses a button on a mouse which in turn, generates a command to the computer

You can use a Form control button or a command button (an ActiveX control) to run a macro that performs an action when a user clicks it. Both these buttons are also known as a push button, which can be set up to automate the printing of a worksheet, filtering data, or calculating numbers. In general, a Form control button and an ActiveX control command button are similar in appearance and function. However, they do have a few differences, which are explained in the following sections.

Button (Form control)

Command button (ActiveX control)

In the sections below, learn how to add a macro to a button in Excel—for Windows or the Mac.

Note: ActiveX controls are not supported on the Mac.

Add a button (Form control)

1. On the Developer tab, in the Controls group, click Insert, and then under Form Controls, click Button

   
   .

2. Click the worksheet location where you want the upper-left corner of the button to appear. The Assign Macro popup window appears.

3. Assign a macro to the button, and then click OK.

4. To specify the control properties of the button, right-click the button, and then click Format Control.

Add a command button (ActiveX control)

1. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, click Command Button

   
   .

2. Click the worksheet location at which you want the upper-left corner of the command button to appear.

3. In the Controls group, click View Code. This launches the Visual Basic Editor. Ensure that Click is chose in the drop-down list on the right. The sub procedure CommandButton1_Click (see the figure below) runs these two macros when the button is clicked: SelectC15 and HelloMessage.

   

4. In the subprocedure for the command button, do either of the following:

   • Enter the name of an existing macro in the workbook. You can find macros by clicking Macros in the Code group. You can run multiple macros from a button by entering the macro names on separate lines inside the subprocedure.

   • As necessary, add your own VBA code.

5. Close the Visual Basic Editor, and click Design Mode

   
   to ensure design mode is off.

6. To run the VBA code that is now part of the button, click the ActiveX command button that you just created.

7. To edit the ActiveX control, make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode.

8. To specify the control properties of the command button, on the Developer tab, in the Controls group, click Properties

   
   . You can also right-click the command button, and then click Properties.

   Note: Before you click Properties, make sure that the object for which you want to examine or change properties is already selected.

   
   The Properties box appears. For detailed information about each property, select the property, and then press F1 to display a Visual Basic Help topic. You can also type the property name in the Visual Basic Help Search box. The following table summarizes the properties that are available.

Add a button (Form control)

Follow these steps:

1. On the Developer tab, click Button

   
   .

2. Click the worksheet location where you want the upper-left corner of the button to appear. The Assign Macro popup window appears.

   Note: If you have already inserted a button, you can right-click on it, and select Assign Macro.

3. Assign a macro to the button and click OK.

4. To specify the control properties of the button, right-click it, and then select Format Control....
    

Add a command button (Visual Basic control)

1. On the Developer tab, click Button

   
   .

2. Click the worksheet location where you want the upper-left corner of the command button to appear.

   Note: If you have already inserted a button, you can right-click on it, and select Assign Macro.

3. In the Assign Macro dialog box, select New, which will open the Visual Basic Editor (VBE) to a pane with the following code:

     Sub ButtonX_Click() 
   
     End Sub

4. In the subprocedure for the command button, between the Sub and End Sub lines, do either of the following:

   • Enter the name of an existing macro in the workbook. You can run multiple macros from a button by typing the macro names on separate lines inside the sub procedure

   • Add your own VBA code.

5. Click Design Mode

   
   to ensure that design mode is off, then close the Visual Basic Editor window.

6. To edit the button, right-click it and choose Visual Basic.

7. To specify the control properties of the button, right-click it, and then select Format Control....

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

See Also

• Add or edit a macro for a control on a worksheet

• Enable or disable macros in Office files

• Enable or disable ActiveX settings in Office files