Thanks a lot Patrick and Anand,
That helped a lot.
Madhavan.R

"Patrick Molloy" wrote:

you can add a userform with a timer control. show the form modeless and have
the timer do something like increment a progress bar when it fires. show thje
form before the call is made to the analysis function.

"Madhavan" wrote:

Hi all,
I have a macro which does some kind of analysis for about 5 mins and
displays the result in a new sheet. I need to display a background animation
or a video file until the macro completes its operation. Is it possible to do
this using Excel VBA or is it out of scope of excel? If it is possible either
by excel or by any other means, pls send me the procedure to do same.
Hope i will get a reply this time.
Thanks a lot in advance.