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.
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
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.
- How to Set Option Button Value in Excel VBA (4 Easy Steps)
- Insert Excel VBA Radio Button Input Box (3 Easy Methods)
- How to Create Button Without Macro in Excel (3 Easy Ways)
- Add Up and Down Buttons in Excel (2 Suitable Examples)
- How to Change Cell Value Using Toggle Button 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.
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.
Things to Remember
- Users can use Shapes instead of Control Button.
- The F5 key works as an alternative to the button.
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.
- How to Use VBA Code for Submit Button in Excel (with Easy Steps)
- How to Clear Cells in Excel with Button (with Detailed Steps)
- Print to PDF Using Macro Button in Excel (5 Macro Variants)
- How to Hide Columns with Button in Excel (4 Suitable Methods)
- Excel VBA: Form Control Checkbox Value (3 Examples)
- Text Alignment with VBA Command Button in Excel (5 Methods)