View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Display a message when a macro is executing

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" wrote:

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