Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel autocalculate result in status bar
Is it possible to access the Autocalculate result (shown in the status bar),
in Excel or VBA, in order to drop it into the clipboard for [paste special value] pasting? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel autocalculate result in status bar
"J_B_#" wrote
: Is it possible to access the Autocalculate result (shown in the status bar), : in Excel or VBA, in order to drop it into the clipboard for [paste special : value] pasting? Check out this previous post http://tinyurl.com/8xeoc Paul D |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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), |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel autocalculate result in status bar
Thanks guys.
Paul's solution is near the mark, but lacks choice of function, so would require several buttons/macros. David's solution doesn't address the need to drop a single value into the clipboard. Obviously one could write a macro to interrogate a combo/list button (not that I have the skill), but that seems inelegant whilst that value must be around in the guts of excel somewhere. John B |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel autocalculate result in status bar
Maybe you'll have to modify a solution to get what you want, but you've
been shown how to get each of the values that you have a choice of (plus a count of text values). Going through the clipboard itself is a rather "inelegant" solution in itself, because no one but you is going to know where those values came from. --- 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 "J_B_#" wrote ... Thanks guys. Paul's solution is near the mark, but lacks choice of function, so would require several buttons/macros. David's solution doesn't address the need to drop a single value into the clipboard. Obviously one could write a macro to interrogate a combo/list button (not that I have the skill), but that seems inelegant whilst that value must be around in the guts of excel somewhere. John B |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel autocalculate result in status bar
"J_B_#" wrote in message
... : Thanks guys. : : Paul's solution is near the mark, but lacks choice of function, so would : require several buttons/macros. : : David's solution doesn't address the need to drop a single value into the : clipboard. : : Obviously one could write a macro to interrogate a combo/list button (not : that I have the skill), but that seems inelegant whilst that value must be : around in the guts of excel somewhere. : : John B Well, I wouldn't say the value 'must' be around since it's possible to store things in class properties that are not publicly exposed. However, I did note that this setting is saved since everytime you open Excel, it remembers what setting you last used. I found that the following registry key (on my computer) stores these settings. HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Options here are the values for each setting Average = 5 Count = a9 Count Nums = 0 Max = 7 Min = 6 Sum = 4 None = ffffffff Unfortunately, it appears excel writes this data only when you exit, so if the user changed the setting while in excel, I don't know of any way to find the value. If you wanted to know what the original value was at time of opening, just read the registry and compare to the list. Not sure if this helps but that's all I could find. Paul D |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel autocalculate result in status bar
Thanks Paul - that's one step nearer to understanding what is/is not available.
Appreciated John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoCalculate | Excel Discussion (Misc queries) | |||
reuest formula for auto update status & status date | Excel Worksheet Functions | |||
Status Bar Autocalculate Width | Excel Worksheet Functions | |||
Excel 2003 status bar autocalculate resize the width | Excel Discussion (Misc queries) | |||
Need a msg box that displays time status or loading status | Excel Programming |