VBA - READ from statusbar / formula calculation percentage

GBagley

Board Regular
Joined
Feb 8, 2011
Messages
84
I know you can write to the status bar, but is there a way to read from it when it is a system given message? Part of a program I'm writing has some lengthy wait times while formulas are being re-calculated and external data is being refreshed. I would like to have my userform mirror what the status bar is saying (ahhh, reassuring update messages :biggrin:). In particular I would like to be able to read the percentage complete when formulas are recalculating, and the "getting data from web", "parsing data"...etc when external data connections are refreshing. Is there a way to do this?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
From what I've gathered in searching, this isn't possible aside from maybe some (far above my knowledge) API use - even then maybe not?
 
Upvote 0
I haver same issue - So I have a counter - when it is over 5000K operations - it updates statusbar with a total count number of where it is in a loop - I put the number inside a bracket. You can stil have screenupdating set to false.
 
Upvote 0

Forum statistics

Threads
1,224,602
Messages
6,179,841
Members
452,948
Latest member
UsmanAli786

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top