Re: Long running macro

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



On Tue, 7 Oct 2008 14:13:02 -0700, SN <SN@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have a long running macro in word. Is there a way to display an animated
GIF while the macro is running?
I am already setting Application.ScreenUpdating = False
in the begginning if the macro and Application.ScreenUpdating = true at
the end.

I am using Office 2003.

Thanks

Unfortunately, animated GIFs don't show any animation, either in the body of a
Word document or in an image control in a userform.

The article http://www.word.mvps.org/FAQs/Userforms/CreateAProgressBar.htm shows
how to display an updating bar in a userform.


--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
.



Relevant Pages

  • Re: How to control macros
    ... values for initalising a UserForm using document variables I'd be willing to ... When I initially create a document from a template, I set a flag to indicate ... You mean call the specific modules from the global macro template yes?. ...
    (microsoft.public.word.vba.general)
  • Re: How to control macros
    ... values for initalising a UserForm using document variables I'd be willing to ... When I initially create a document from a template, I set a flag to indicate ... As for a "global macro template", I don't have one - at least not for the ...
    (microsoft.public.word.vba.general)
  • Re: List box not working on my userform
    ... I have another problem now - when running the compile or run userform I get ... Open the macro code in the VBA editor. ... manipulate the Selection in headers/footers. ...
    (microsoft.public.word.vba.userforms)
  • Re: toolbar button for user form
    ... regular macro is what you can assign to a toolbar button. ... I'll assume you kept the default name for a userform, "UserForm1", although ... Then assign a toolbar button to the LaunchMyUserForm macro. ... Now....I need to assign this user form to a toolbar ...
    (microsoft.public.word.vba.general)
  • Re: Word User Form vs ? Form
    ... Thanks, Jay, for a quick intro to forms! ... A userform, as you've already discovered, is based on macro code. ... Dim myUF As MyUserForm ...
    (microsoft.public.office.misc)