This may give you some ideas.
http://www.andypope.info/vba/pmeter.htm

Cheers
Andy

wrote:
I have a form that shows the progression bar of my macro.
Similar to a %complete bar. Would it be possible to add
something interesting like an animation feature such as a
running man to this form? How could I go about doing this?
Any other suggestions on types of animation characters
would be appreciated as well as how to use them.

Thank You

--

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