jase71ds
Board Regular
- Joined
- Oct 23, 2006
- Messages
- 137
- Office Version
- 365
- Platform
- Windows
Hi,
I have an Aut
pen macro that cleans up data before allowing the user to begin. This only takes around 8 seconds, but I wanted to put a message asking the user to please wait a moment while we tidy things up.
What I found is that when I start my Aut
pen macro with MsgBox("Please wait a moment...") - the rest of the code will not run until the user hits "OK"
My preference would be that I could start by showing the message, but that Excel would continue to execute the remainder of the code and not wait until the user clears out the message.
Is this doable?
Thanks for any help.
Jase.
I have an Aut

What I found is that when I start my Aut

My preference would be that I could start by showing the message, but that Excel would continue to execute the remainder of the code and not wait until the user clears out the message.
Is this doable?
Thanks for any help.
Jase.