Using Pop Up Calculator in Excel

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.
Bright01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

D PatelD Patel, Software EngineerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob HensonFinance AnalystCommented:
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
Bright01Author Commented:
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
Rob HensonFinance AnalystCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.