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.

Hi,

I personally feel that it might take up unecessary system resource

Are you usign a user form by any chance? If you are using a user form you
could use a progress bar to show the status?

Anand



"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.

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.

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.