Solved

Using Pop Up Calculator in Excel

Posted on 2016-10-12
4
118 Views
Last Modified: 2016-10-12
EE Pros,

Greetings!  I'm looking for help in using a Macro to have a Pop-Up Calculator appear in a spreadsheet.  To fire the macro, I'd like to be able to use the Control + C to show it and a Control + H to hide it.  Is there a way to use the built in calculator that's part of "Accessories" ?  And finally, how can I control the Pop Up to be resident on the screen so I can move within Spreadsheets?

Much thanks in advance!

B.
0
Comment
Question by:Bright01
  • 2
4 Comments
 
LVL 7

Accepted Solution

by:
D Patel earned 350 total points
ID: 41840085
Hi Bright01,

Put the following code in VBA....

Sub popupCalc()
Dim RetVal
RetVal = Shell("C:\WINDOWS\system32\CALC.EXE", 1) 
End Sub

Open in new window


Open the Macro Dialog Box,,,
Open Macro
Click the Option Button and Assign the Key (Ctrl+C)..
Assign Key
Regards,
D Patel
0
 
LVL 33

Assisted Solution

by:Rob Henson
Rob Henson earned 150 total points
ID: 41840108
Why would you want to show the calculator in Excel?? Excel is a calculator.

Rather than Ctrl + C to bring up the calculator and then the keystrokes to put in figures and operators, type = and then the same keystrokes and operators to get a result.

Ctrl + C and Ctrl + H are probably not good options to choose if you do go down this route; by default Ctrl + C is Copy and Ctrl + H brings up the Find and Replace dialog.  Adding Shift to the key combo as suggested by D Patel above gets round this.
0
 

Assisted Solution

by:Bright01
Bright01 earned 0 total points
ID: 41840281
D.

Thanks for the coaching!  Works perfectly.  

Rob,

The reason for the calculator is that my Workbook has input areas that when someone wants to input a set of numbers, the calculator function is a big help.

B.
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41840332
Do you mean they want to add up some numbers on a calculator and then put the result into Excel???

Again, why not just type the numbers into a cell with a plus sign between them or whatever calculations they need to do?? If there is then a query at a later date how they came by a certain number, at least you will have the workings in the cell.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question