APPEARENCES DURING THE MACRO RUN PERIOD

[K]

Hi all, i just want know that is it possible that if you have macro
which takes about 1 to 2 minutes to complete its job and during that
time when you waiting for macro to finsih its job you get something
flashi on your screen like you add some thing in your macro that when
your macro is running you get something on your screen like animation
moving thing or something like flashi thing or just which takes your
attention during the macro run and as soon as macro finish its job
that thing should also diappear. i know this a stupid question but
there is no end of dicovering things. if any friend know anything
like this or know any web which i can look at please do let me know.
Many thanks.

 

[paul.robinson]

Hi
Search this group for
make a progress bar
or
make a progress bar indicator

regards
Paul

 

[Mark Ivey]

Are you wanting a progress bar, or are you noticing that our screen flashes
as your macro runs?

If you are wanting a progress bar, there are several examples on the web
shownig how to create one. Just do a Google search for "Excel VBA Progress
Bar".

Some examples:

http://www.andypope.info/vba/pmeter.htm

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

If the latter, you are seeing your screen flash while your macro is running...
This is because your Application is updating as your macro performs certain
functions. You can actually disable this feature and inturn speed up your
macro's run time a bit as well. The command to disable your screen updating
is:

Applicaton.ScreenUpdating = False

Put that at the beginning of your macro to disable the application screen
updating and you will not see any flashing screens as your macro runs.

Just don't forget to change this feature back to TRUE at the end of your
macro:

Application.ScreenUpdating = True

Mark Ivey