15
Oct
stored in: bookmarks
-
Sub ShowProgress()
' make StatusBar visible
Application.DisplayStatusBar = True'First Message
Application.StatusBar = String(5, ChrW(9609)) & "Working..."Application.Wait Now + TimeValue("00:00:02") '<-- Replace this line with your own code to do something
'Second Message
Application.StatusBar = String(10, ChrW(9609)) & "Still Working..."Application.Wait Now + TimeValue("00:00:02") '<-- Replace this line with your own code to do something
'Last Message
Application.StatusBar = String(15, ChrW(9609)) & "Almost Done..."Application.Wait Now + TimeValue("00:00:02") '<-- Replace this line with your own code to do something
'Relinquish the StatusBar
Application.StatusBar = FalseEnd Sub
Leave a Reply
You must be logged in to post a comment.