Message to user while macro is running

wcassell

New Member
Joined
Mar 9, 2002
Messages
24
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
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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
 
Upvote 0
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"
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top