AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
If you do not reset the StatusBar after you have finished with it your last message will remain until the application is closed. PowerPoint Application.StatusBar = "3 of 100" If you change the status bar to display a message to the user - make sure you reset it. ' When the macro has finished reset the status bar ' Make sure that the status bar is visible If your macro takes a bit of time to complete using the status bar will ensure that the user does not think that the macro has crashed or is not responding. If you switch the ScreenUpdating off to prevent the screen from flickering it is worth using the Status bar to keep the user informed about the current status of the macro. StatusBar messages are still displayed even when ScreenUpdating is turned off.Īt the end of the process you must change the StatusBar property to False so it can return to its normal status. This should definitely be used when you turn ScreenUpdating off and there is no sign of activity of the screen. This is an easy way to keep users informed of progress during a length macro. The StatusBar property allows you to assign a text string to be displayed on the left of the statusbar.
0 Comments
Read More
Leave a Reply. |