Progess Indicator - "Circle" Indicator By Andy Pope

I want to revise Andy Pope's code to allow the entire screen to be displayed with the "Circle" Progress Indicator .

I would like something like the one we use in our Excel Help Forum when we are waiting to be redirected from the log on screen to the forum.

Here is the begin of the code.

Please Login or Register  to view this content.

I tried to follow the code to copy and paste it in my own spreadsheet, but I can not follow what is going on.

Can anyone help to adstract the "Circle" Progress Indicator from his code?
The rest of the code can be found here
http://www.andypope.info/vba/pmeter.htm

The code you have posted is for the animation of a cirlce either growing or shrinking in relation to another.

Basically the code calculates the new width/height value for the changing image in relation to a percentage of the static image. Once resized it is then centered.

Most people only really have problems with understanding where in there own code the progress meter code should fit. Basically when should they call the routine.

so why not post you code and explain where the delay is that you want to report progress to the user.

If you select the 2 ovals, textbox and checkbox from multi page2 and move them on to the userfrom you can delete the multipage and all the other controls.

You then need to remove the calls to those other meters in the initialize event and run progress meters button

Only code required is

Please Login or Register  to view this content.

see attached