Pinterest Pixel

Use Calculator By Using Macros In Excel

Inside Excel, there is that cool functionality of launching the calculator from there, and you can do... read more

Download Excel Workbook
Bryan
Posted on

Overview

Use Calculator By Using Macros In Excel | MyExcelOnline Use Calculator By Using Macros In Excel | MyExcelOnline

Inside Excel, there is that cool functionality of launching the calculator from there, and you can do that with Excel Macros! You can now perform some quick calculations using the calculator.

Make sure your Excel has the Developer Tab enabled following this tutorial.

I explain how you can do this below step by step!

What does it do?

Launch the Calculator from Excel

Copy Source Code:


Sub UseCalculator()

'Open the Calculator for quick calculations
Application.ActivateMicrosoftApp Index:=0

End Sub

Final Result: 

Use Calculator By Using Macros In Excel

Exercise Workbook:

Use Calculator By Using Macros In Excel | MyExcelOnline

Download excel workbookUse-Calcuator.xlsm


STEP 1: Go to Developer > Code > Visual Basic

Use Calculator

 

STEP 2: Paste in your code and Select Save. Close the window afterwards.

Use Calculator By Using Macros In Excel

 

STEP 3: Let us test it out!

Go to Developer > Code > Macros

Unmerge All Cells Using Macros In Excel

 

Make sure your macro is selected. Click Run.

Use Calculator By Using Macros In Excel

 

With just one click, you have launched the calculator inside Excel!

 Use Calculator By Using Macros In Excel

 

How to Use Calculator By Using Macros In Excel

See also  Refresh All Pivot Tables Using Macros In Excel

 

101 Macros Book

If you like this Excel tip, please share it
Use Calculator By Using Macros In Excel | MyExcelOnline Use Calculator By Using Macros In Excel | MyExcelOnline
Use Calculator By Using Macros In Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...