All these responses' were great .. Thank you all!!

"Tom Ogilvy" wrote in message
...
http://www.j-walk.com/ss/excel/tips/tip34.htm

is one way. show it at the begining of your macro, update it as the macro
progresses, drop it at the end.

--
Regards,
Tom Ogilvy



"WANNABE" wrote:

a procedure is running behind the scenes??? The only thing I have used
is
the msgbox but that pauses the process until you hit a key, and I am
looking
to display a message for about 8 seconds, which is how long the process
should take, or until the process completes. How do you do both ??