# How to Make a Calculate Button in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Users can use the F5 key or a Form Control Button to run a macro to calculate operations within worksheets. In this article, we demonstrate the step-by-step procedures to make a calculate button in Excel.

## Step-by-Step Procedures to Make a Calculate Button in Excel

A calculate button requires a macro to be assigned to it. And clicking the button results in running the macro, thus executing the assigned task.

Follow the below section to make a calculate button in Excel.

### Step 1: Generating a Macro for a Specific Task

Typical worksheets contain multiple formulas that may require recalculation. Letâ€™s say we have a worksheet that displays the Countdown to an ongoing exam. Now, we want to find the time spent each time we click on the Calculate Button.

• Go to the Developer tab > Visual Basic or ALT+F11 to open the Microsoft Visual Basic.
• Then move to Insert > Module. The module window appears.
• Paste the following macro in the Module.
``````Sub RecalculateActivesheet()
ActiveSheet.Calculate
End Sub``````

Read More: How to Create a Macro Button in Excel

### Step 2: Inserting and Modifying a Calculate Button

• Hover over the Developer tab.
• Click on Insert (in the Controls section).
• Select Button (Form Control).

• Draw the button as shown in the latter image.

• Drawing a calculate or Form Control Button takes you to the Assign Macro. As itâ€™s not possible to Edit Text or Format of the button after macro assigning, just click OK when the Assign Macro window appears.

• Right click on the button. Select Edit Text from the Context Menu. Give a suitable name (i.e., Calculate) to the button.

• Now, right click on the button to apply Format Control.

• Choose favorable Font, Font Style, Size, and Color form the Format Control Afterward, click OK.

### Step 3: Assigning Macro to Calculate Button

After modifying the button depiction, users need to assign the macro.

• Right click on the button. Choose Assign Macro from the Context Menu.

• The Assign Macro window appears. Choose the existing inserted macro, then click OK.

Read More: How to Create Button to Link to Another Sheet in Excel

### Step 4: Saving File as Macro Enabled Excel File Extension (.xlsm)

For further use, users need to save the workbook file as an Excel Macro-Enabled Workbook(*.xlsm).

• Move to File > Save As.
• Select the File Typeâ€“ Excel Macro-Enabled Workbook(*.xlsm).
• Click on Save.

Read More: How to Edit a Macro Button in Excel

### Step 5: Testing Calculate Button

After executing Steps 1 to 4, users can test the Calculate Button.

• Return to the worksheet and click on the Calculate You see, Excel recalculates the formulas existing in the active worksheet.

Read More: How to Create & Apply Option Button Click Event in Excel VBA

## Things to Remember

• Users can use Shapes instead of Control Button.
• The F5 key works as an alternative to the button.

## Conclusion

This article demonstrates step-by-step procedures to make a calculate button in Excel. The button works as an execution key for an assigned macro. We hope these discussed steps help you to insert a calculate button for yourself.

## Related Articles

Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF