Solved

Using Pop Up Calculator in Excel

Posted on 2016-10-12
4
92 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 6

Accepted Solution

by:
DPatel 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 32

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 32

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

809 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