Thread: excel autocalculate result in status bar
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
  
Posts: 903
Default excel autocalculate result in status bar
Hi Paul,
Thanks for the reference concerning the fact that filtering affects
the reported values for SUM, etc on the Status Bar, I have
updated my page accordingly. The macro shows all of the
values in one message box; whereas, you have to choose which
value you are interested in when viewing in Excel.

Macro to simulate StatusBar Reporting (#simulation)
http://www.mvps.org/dmcritchie/excel...htm#simulation
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"PaulD" <nospam wrote ...
"J_B_#" wrote
: Is it possible to access the Autocalculate result (shown in the status bar),


Reply With QuoteReply With Quote