You may want to look at the way John Walkenbach showed a progress bar:
http://j-walk.com/ss/excel/tips/tip34.htm
It sounds like it'd be the same.
cdb wrote:
I want to create a form that displays when I run a macro. On this form I
would like to display 6 images in turn to represent the progress of the macro
and cycle through them (the images being differing numbers of black blocks,
like a loading bar).
I have put the images on the form, but I don't know how to hide all but the
first one, then cycle through the rest and showing each for 2 seconds, then
going back to the start.
Any help??
--
Dave Peterson