Splash or message box that doesnt pause

  • Thread starter Thread starter travis
  • Start date Start date
T

travis

I want to pop up a message during the execution of a VBA sub without
actually freezing it.

If I put a message box there, the sub will stop executing until the
user has hit ok. I dont want that, I want the sub to continue running
while the message is put up on the screen.

How do I do that?

Travis
 
The way to do this is to create a userform and show that, and run the code
from within the form.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pausing a macro during execution 1
How to Pause an Excel VBA script without freezing excel 1
Stop / Pause a Macro using Pause button 4
Splash Screen Behavior 2
Splash Screen Timing 4
Excel Providing user message when RED X clicked & properly closing application. 2
How to get pi to appear in a message box when coded using VBA 0
Stop running macro button, like Ctrl-Break button 8

Back
Top