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
--
Mark Ivey
"K" wrote:
> 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.
>
Similar Threads
