Help for a Progress bar. Looking for estimated time remaing, but also have a PAUSE

There are TONS of Progress bars and many with estimated time remaining, but I would like to be able to PAUSE (from a userform) and then have the code pause and then resumed, to continue with the progress, but subtract the effects of the time while paused.

I would be basing this off a for next of crows on column a, so percent ect would be based on
progress of that loop.

Additionally (this would be great, but would probably be MUCH harder...) but iif an error contdion occurs, to also pause the timer. I realize I would need to have error code in each sub.function if this was to be implemented...

ANy suggestions?
Thanks
Mc

A VBA progress bar can show the percentage of a task, generally a counter division,
but for the time you must elaborate what is your strategy how to estimate the time remaining.
Do not forget either to attach a workbook, so far better to avoid a generic code
or you are pretty confident with your Excel VBA skills to fit any starter code to your specific need.

For starters the classic percentage bad slow VBA progress bar often found on web and the corrected version in this thread …