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

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.

Making a Calculate Button in Excel


Download Excel Workbook

Download the below xlsm file to practice with.


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 Visit This Link if you don’t have the Developer tab in your ribbon.
  • Then move to Insert > Module. The module window appears.
  • Paste the following macro in the Module.
Sub RecalculateActivesheet()
  ActiveSheet.Calculate
End Sub

Macro


Step 2: Inserting and Modifying a Calculate Button

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

Form Control Button

  • 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.

Edit Text

  • 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.

Making a Calculate Button in Excel


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 Assign Macro to Button in Excel (2 Easy Methods)


Similar Readings


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 TypeExcel Macro-Enabled Workbook(*.xlsm).
  • Click on Save.

Read More: VBA Code for Save Button in Excel (4 Variants)


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.

Recalculate Active Worksheet using Calculate Button


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.

Do check out our awesome website, Exceldemy, to find interesting articles on Excel.


Related Articles

Maruf Islam

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

Leave a reply

ExcelDemy
Logo