View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Lloyd Don Lloyd is offline
external usenet poster
 
Posts: 119
Default msg box while operation is running.

Hi Kevin,
Another is to use a Text Box e.g. for "Text Box 12"

At the start of code

ActiveSheet.Shapes ("Text Box 12").Visible=True

and at the end

ActiveSheet.Shapes ("Text Box 12").Visible=False

Bear in mind though the text box is always there even if you can't see it :)

Regards,
Don

"Keivn Green" wrote in message
...
Is there a way to make a message box come up only while a macro is running
and then have it go away once the procedure is done?