pop up during calculation

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

I would like a temporary message box to appear momentarily when a macro is
activated.

The macro typically takes 10 seconds or more to run and at the start i would
like a box to pop up saying "calculation in progress" for a few seconds and
then disappear without the need to press a button.

Can anyone help?

Thanks, Roger
 
Make a userform with the message you want to display, then show it at
the beginning of your procedure and close (unload) it at the end.

Cliff Edwards
 
here's an option. create a userform with a label on it

Sub test()
With UserForm1
.Show vbModeless
.Label1.Caption = "Calculating...Please Wait"
End With
DoEvents
Application.Wait (Now() + TimeValue("00:00:10"))
Unload UserForm1
End Sub
 
I usually use
Application.StatusBar = "Enter your message" 'to display the message

and
Application.StatusBar = False 'to turn it off.
 
Thanks - thats quite nice

Can one change the font to bold do you know?

Regards,

Roger
 
Can one change the font to bold do you know?

No. The font and style of the StatusBar is fixed and cannot be changed,.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top