Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Application.StatusBar Stops Displaying Info During a Macro Run

Status
Not open for further replies.

YerMom

Programmer
Oct 3, 2006
127
US
I've written a number of Word macros that are time-consuming, so in them I write progress information to the Application.StatusBar. On a number of occasions when running my macros, the StatusBar seems to freeze -- information ceases to get written to it, but my macro continues to run and I know that within the macro it is still issuing calls to write information to the StatusBar.

I read somewhere that this kind of behaviour often happens when you invoke macros directly from the macro editor instead of from for example, a button in the Word UI.
However, this problem occurs regularly even when I start my macros from a button in the Word UI.

Has anyone else experienced this problem. If so, what should I do to prevent the problem?

Thanks,
Steve
 
May or may not work, but easy enough to try: after your line of code updating the Statusbar, insert a DoEvents command.


Regards,
Mike
 
Mike,

Thanks for your help. I'll give this a try and let you know what happens.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top