Splash or message box that doesnt pause
 

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

Splash or message box that doesnt pause
 

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)

"travis" wrote in message
oups.com...
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