Microsoft is not extending the Mainstream Support phase for Microsoft Visual Basic 6.0 in any way. If you do not reset the StatusBar after you have finished with it your last message will remain until the application is closed. Unfortunate, your VBA code does not see the processing internally in database engine. Microsoft Visual Basic 6.0 has transitioned to Extended Support which runs through March 31, 2008. 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
Leave a Reply. |