Status Bar in MsExcel VBA

[OlivierS]

Hi,

I have set the following code in my Macro:



'Add a message
Application.DisplayStatusBar = True
Application.StatusBar = "Please wait ... I'm creating your " & strFrequency & " report(s)"

But can't see anything when the macro is running.
Where is it meant to be displayed?

Thank you

 

[mole999]

bottom left of the screen. if you step through your code does it display (it could be too quick when run in code)

 

[OlivierS]

Thank you @mole999

Is there an easy way to display a message box rather than using the status bar (if I can't see it, I doubt my colleagues will !

 

[mole999]

Call MsgBox("Please wait ... I'm creating your " & strFrequency & " report(s)", vbExclamation, Application.Name)

 

[OlivierS]

@mole999 but the message box will stop the code to execute, no ?

 

[mole999]

yes. code stops until acknowledged

 

[Teeroy]

You can use a modeless userform to display the message. That will not stop code execution.

 

[mole999]

in which case

Call MsgBox("Please wait ... I'm creating your " & strFrequency & " report(s)", vbExclamation Or vbSystemModal, Application.Name)

 

[Teeroy]

@mole999, that's still modal for excel, it also keeps the msgbox persistently on top of all system windows. I don't think that there is any way to make a standard msgbox modeless.