I've never used it myself, but myabe this would be of use?

http://www.cpearson.com/excel/Progress.htm

Pete.

-----Original Message-----
Is there a way I can show the progress of a long piece of
code by
showing information on a UserForm, even when
application.screenupdating=false?

If the screen isn't updating the information being
written to the form
isn't displayed until the application.screenupdtaing=true.

If I leave application.screenupdtaing=true the code takes
longer to run
and it makes the screen flicker (in a really annoying
fashion!)

I hope there is a way where I can have UserForms updating
with the rest
of the application not updating?


I hope someone out there can help me, as I am really
stumped on this one.


TIA

.