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

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

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.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• vba
• excel macros
• macro
• learn macros
• write macros
• pause macros
• time delay in a macro
• stop a macro

[yomartiniux]

Pretty nice tutorial. It was very useful to me