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?
|