| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Status Bar Calculating Cells 50%
Excel calcultes how many calculations are on the sheet
and when it does a recalc displays at the bottom of the screen the status, e.g. calculating cell 5%, 10% etc... Is there any way to get at these numbers in code ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Status Bar Calculating Cells 50%
Neil,
I don't believe there is any way to determine Excel's calculation progress. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Neil" wrote in message ... Excel calcultes how many calculations are on the sheet and when it does a recalc displays at the bottom of the screen the status, e.g. calculating cell 5%, 10% etc... Is there any way to get at these numbers in code ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Status Bar Calculating Cells 50%
No, I wouldn't think so; while excel is calculating, your code is suspended.
That may not be true of a UDF that is being calculated by the calculation engine. You might have your UDF read the statusbar - I have never tried that. -- Regards, Tom Ogilvy "Neil" wrote in message ... Excel calcultes how many calculations are on the sheet and when it does a recalc displays at the bottom of the screen the status, e.g. calculating cell 5%, 10% etc... Is there any way to get at these numbers in code ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reuest formula for auto update status & status date | Excel Worksheet Functions | |||
| Calculating: (1 Processor(s)): 25% MESSAGE ON STATUS BAR | Excel Discussion (Misc queries) | |||
| Avoiding Calculating Cells on the Status bar | Excel Discussion (Misc queries) | |||
| Calculating Cells n% message in Status bar | Excel Discussion (Misc queries) | |||
| autofilter calculating in Status bar | Excel Discussion (Misc queries) | |||
![Neil[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
