Thread: Display a message when a macro is executing
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
alexrs2k alexrs2k is offline
external usenet poster
  
Posts: 37
Default Display a message when a macro is executing
Thanks!

"Mike H" wrote:

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?

Reply With QuoteReply With Quote