 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / February 2005How do you display a progress bar to user?
I have created a fairly simple macro that will take quite a long time to run. What I'd like to do is present something on the order of a progress bar so that the user has some warm fuzzy that the macro isn't simply hung. Is there a way to do this in VBA for a Word document (Word 97+)? This progress bar would not necessarily have to be a grahic. It could be text. Something like "Working on item x of 20 items" where the macro updates x as it loops through the items. I don't want to use MsgBox because that requires user to respond. Thanks Jim You can put text in the StatusBar. Or display a UserForm with a progressbar (or whatever you like) on it. >I have created a fairly simple macro that will take quite a long time to >run. What I'd like to do is present something on the order of a progress [quoted text clipped - 9 lines] > Thanks > Jim StatusBar works for the most part. During first phase of macro, it works great. During second phase, Word is overwriting the StatusBar itself so quickly that I can't see what my macro is putting there. But then during the second phase the document is scrolling down so the user can judge by that that the macro is making progress. If I want to get more elegant than that I'll just have to break down and get a book on VBA and learn about UserForms:-) Thanks Jim > You can put text in the StatusBar. Or display a UserForm with a progressbar > (or whatever you like) on it. [quoted text clipped - 12 lines] >>Thanks >>Jim UserForms have the additional advantage that you can provide the ability to interrupt the macro while it's running (which might or might not be a good thing ...) > StatusBar works for the most part. During first phase of macro, it works > great. During second phase, Word is overwriting the StatusBar itself so [quoted text clipped - 24 lines] >>>Thanks >>>Jim |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.