Can I get a popup MsgBox without stopping/pausing VBA program?

  • Thread starter Thread starter Gum
  • Start date Start date
G

Gum

I would like to get a MsgBox pop up to alert the user to a condition without
pausing or stopping the execution of the program. The MsgBox would have the
information and a button to close.
 
I would like to get a MsgBox pop up to alert the user to a condition without
pausing or stopping the execution of the program. The MsgBox would have the
information and a button to close.
Click to expand...

I'm pretty sure a MsgBox is modal.

What I'd do is design a Form to emulate a message box. That should do
the job nicely.

Cheers - Kirk
 
I take the easy route and use:

Application.statusbar = "some important notice here"
....

And at the end of the code:

application.statusbar = false

To give it back to excel.
 
Back
Top