Hi Jim,

I have a few alternatives here.
http://www.andypope.info/vba/pmeter.htm

If you wanted to create something like the Delete progress then you will
need a set of images laid out on the userform. Then where the code
normally extends the progress bar you will need to change the visibilty
of the images to mimic the animation.

Cheers
Andy

JK wrote:
Thank you, Judy

Yes, I have the book. But John's progress indicator is not exactly what I'm
looking for.

Regards

"JulieD" wrote in message
...

Hi Jim

John Walkenbach has a couple of approaches in his book "Power Programming
with Excel 200x" ... the book is definitely worth getting hold of if you
don't already have it. He also has an article on his website on how to do
it http://j-walk.com/ss/excel/tips/tip34.htm - Displaying a Progress
Indicator

Cheers
JulieD


"JK" wrote in message
. ..

For visual effect during a long macro, I would show an "animated"

progress

indicator similar to the one used by MS. Not to track progress, just a
series of looping green tiles for the user to look at during the macro.

Does anyone know how to write, or where I can obtain? Thank you.

Jim Kobzeff







--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info