Accessing/Using Sum, Max, Etc on Status Bar

  • Thread starter Thread starter JMay
  • Start date Start date
J

JMay

I use the "on-screen" summing feature that shows up at the bottom of my
excel screen - 1st I've forgotten the official name of it which probably is
why I cant find how it is either set up, or disabled (if someone would
possibly wish to), but anyway...

Is there a way to customize it, say to add a "Diff" option.
Example, on screen I use the add to click on cells and get the total, very
helpful;
but all too often I'd like to get the difference (subtract, not add) in two
numbers -- I've resorted to setting up several spreadsheets where I enter
numbers which will be subtracted "as negatives" only so that I can
"on-screen" quickly get the "difference", but this gets annoying...

The natural solution is to create a "Diff" option on the right-click menu to
accomplish,,, Can this be done? Or must it be done by Bill G?
Thanks
 
JMay,

There are a few options available for the AutoCalculate feature on the
Status Bar, unfortunately "difference" is not one of them. If you right
click on the Status Bar you will get a drop-down box with the various
options available.

PC
 
If I were to click on B5, then holding down the Control key and click on D9
while the code below has these cells hardcoded (B5 and D9), what do I need
to change in this code to capture the same B5 and D9 (meaning the currently
selected cells - B5 and D9), not hardcoded (as shown below)?

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 7/18/2003 by James May
'
Dim num1 As Integer
Dim num2 As Integer
num1 = Range("B5")
num2 = Range("D9")
MsgBox "The Difference is " & num1 - num2, , MyTitle
End Sub

Tks,
 
Back
Top