Display a message when a macro is executing

  • Thread starter Thread starter alexrs2k
  • Start date Start date
Hi,

The usual way to do this is by using the sratus bar

Sub MyCode()
Application.DisplayStatusBar = True
Application.StatusBar = "Please wait, running code"
'Your code goes here
Application.StatusBar = False
End Sub

Mike
 
Thanks!

Mike H said:
Hi,

The usual way to do this is by using the sratus bar

Sub MyCode()
Application.DisplayStatusBar = True
Application.StatusBar = "Please wait, running code"
'Your code goes here
Application.StatusBar = False
End Sub

Mike
Click to expand...
 
Back
Top