Display a message when a macro is executing

[alexrs2k]

Hi.
How can I display a message while a macro is executing?

 

[Mike H]

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

 

[alexrs2k]

Thanks!

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