Macro Progress Bar

Hi,
As i have a pretty "complex" macro, which takes around 20-30 minutes to do (honestly)....
I was wondering if there was a way to create a progress bar just showing me how many % it has done so for?

Or even tell me which sub routine it is up to? (but % would probably be better)

And preferably a pop-up box one?.. not one on the status bar because i have stuff updated on the status bar already...
Thanks in advance =]

See http://www.andypope.info/vba/pmeter.htm

i've had a look at the code for a few minutes & i've inserted my code where appropriate but it doesnt seem to work?

I guess i can try a bit later and put some into it but is there a way to just get me to code for the progress bar?

Post your code.

Please Login or Register  to view this content.

What am I missing? Doesn't this line do what you want?

Please Login or Register  to view this content.

there are other parts to the code which i have not included, which is whole another macro (which i have not finalized yet) hence why i was hoping that you could work with what i've provided you & i'll work around that.

I might, but I don't see what you're trying to do. You have a progress indicator in the status bar now that reports progress of the only loop in your code.

i've inserted my code where appropriate but it doesnt seem to work?

What code have you inserted where?

I opened up the link that you sent me.
I opened up the Progressmeters.xls file..
and i put all the code that i've put up in my previous message in:

Please Login or Register  to view this content.

i put my code in:

Please Login or Register  to view this content.

There is a lot more code, which will not fit into this message. Thank You

That's going to execute whatever code you put there 100 times - is that what you want?

The thrust of Andy's examples were to show how to create progress meters -- you have to adapt the code to your application.

Are you trying to show the percent of lines read from the given file?

no what im after is a progress bar for the whole macro.

Say for instance, from the time i execute my macro, it takes 10 minutes to complete "the whole macro" once, i would like a progress bar telling me the progress of the macro.

Just like the one in my code which shows the progress of the loop, but i want one for the "whole" macro...

Then you need to have points in the macro that you can compute relative progress.

and what does that exactly mean?

I'm sure someone has code which has this, it shouldn't be too complicated?

It's complicated in the fact that you have to determine how far the macro has progressed because you are not reporting a loop only process.

So you need to pick points in your code that reflect progress points in your whole macro.

and how do i do that exactly?

so can that be done when it changes subroutines maybe?

i've prob got like 12 subroutines so. How many it's done so far divided by total subroutines times 100??

how would i go about implimenting that exactly..

You would use something like the following.
Assume 3 routines that each take 1/3 of the processing time.

Please Login or Register  to view this content.

awesome,
that helped..

my final result is attached.

thanks guys for all your time.