I've written a macro that is used by others at my work. It's
accesssed/run through a userform that covers the whole screen, so all
the flickering is avoided. The only downside is that, as the macro
takes some time to run, to some people, it appears that nothing is
happening.

I tried to create a progress bar by putting textboxes side by side and
then changeing the backcolours of these at various points though the
code, but found that this didn't work (although it did work when
stepping through the coded step by step!).

Does anyone know a way to indicate the progress as the macro runs ??


--
CPhil
------------------------------------------------------------------------
CPhil's Profile: http://www.excelforum.com/member.php...o&userid=29842
View this thread: http://www.excelforum.com/showthread...hreadid=532295