Calcular Tool

[Penny]

Is there anyway that I can anchor the MS calculator tool directly into a
worksheet or is there a macro out there that will act as one? I have a sales
forecast tool that is interactive (for users to complete) and if an error is
made, I would like them to have a tool to work out the variance.

 

[Mike H]

Penny,


I assume (maybe incorrectly) you mean the calculator that comes bundled with
Windows.

There's no 'Always on Top' setting for calculator but here's a thought, why
can't your users work out the variance in Excel which can do everyting
calculator can and a lot more besides. If that's no good then tile Excel &
the Calculator.

Mike

 

[Penny]

Hi Mike:

That is absolutely the best way to do it, I agree. I hoped to be able to
anchor the Windows tool (you're right) into a spreadsheet or some form of a
like object (macro driven) to assist the users in dealing with this project.
There are going to be so many variances (+/- CurrYr, +/-YAG, Region, segment
and region variances) that the calculations would be crazy, that I hoped to
provide them with a tool in their work area of the spreadsheet to accomplish
all options. A calculator, seemed to be the best. This is an immense
project and I'm trying to make it as interactive as possible for the planner.

Looks like I'm out?

Thanks again, Penny

 

[Gord Dibben]

Sub Calc_Pop()
On Error Resume Next
Shell ("calc.exe"), vbNormalFocus
If Err <> 0 Then _
MsgBox "Calculator is not on your computer."
End Sub

Assign to a button and/or shortcut key.


Gord Dibben MS Excel MVP