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.

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" wrote:

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.

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

"Mike H" wrote:

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" wrote:

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.

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


On Thu, 17 Jul 2008 12:20:01 -0700, Penny
wrote:

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.