Message to user while macro is running

[wcassell]

I'm guessing that this is something that's pretty easy, but I can't work my way around it. I've tried searching the board, but I keep getting an error message.

I have a macro that runs for 10-15 seconds. I'd like to have a message box (or user form???) show up while the macro is running telling the user that the job is running.

Any direction would be appreciated.

Thanks,
Will

[Tom Schreiner]

Hi
Best way I have found to do this is either directly placing a message in the worksheet or create a userform with your message, place a call to your macro in the intitialize event, and show the form where you were intitially running your macro.
Unload the form after your macro is completed running.
If you need more details, please re-post.
Tom

[ This Message was edited by: TsTom on 2002-04-04 08:45 ]

[Al Chara]

Try creating a userform. Have the first line of your macro be YourUserform.show and the last line be YourUserform.hide. Make a label on the userform that says "macro is running"

[Tom Schreiner]

Al Chara?
Won't the code halt if the userform is modal?
Tom

[wcassell]

Thanks for the help. I've got the user form created, but it gets stuck after displaying it. How do you get it to keep running through the macro?

Thanks again,
Will

[Al Chara]

Good point, I don't know how to get around this. Anyone else know?

[Spock's Brain]

You are putting the code in a module that calls the Userform message?
Try putting the macro code inside the Userform instead of putting it in the module.