Excel Macro VBA Tip 23 - Put a Time Delay in Macros Pause a Macro for a Given Amount of Time Excel

This Excel video tutorial will show you how to create or write a piece of code in an Excel macro that will pause the macro. This will basically add a time-delay to the macro. That means that you can pause or stop the execution of a macro for a prescribed length of time.

You will learn how to pause a macro for any number of seconds, minutes, and hours. This is a really cool thing you can do in an Excel macro and is easy to learn. You will also learn how to stop a paused macro as well as what happens when you pause a macro in Excel.


Have a great day!

[jaypatel]

thank you very easy way you make my day

[TarunSharma-jstf]

i want to run the same macro but i don't want my rest of the excel to freeze. how can i do that?

[MySpazmo]

i used message box to make a macro that spams you with the same message 700 times.