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)
"Roger on Excel" wrote in message
...
Thanks - thats quite nice
Can one change the font to bold do you know?
Regards,
Roger
"Barb Reinhardt" wrote:
I usually use
Application.StatusBar = "Enter your message" 'to display the message
and
Application.StatusBar = False 'to turn it off.
--
HTH,
Barb Reinhardt
"Roger on Excel" wrote:
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