023. How to use TIMER in VBA to run a MACRO at a Constant INTERVAL of TIME (and how to stop it)

Many of you asked me on how to run a code while they are asleep or at a certain time interval. How cool would it be to have your report done at night while you are sleeping at home? :)

In this tutorial, you will learn how to use the Application.Ontime Method to run a macro at a certain frequency. You will also learn how to stop the macro after a specific number of times. All you need to do is to specify a time interval and write the code you need to execute! As simple as that.

Channel content: Excel, excel tutorial, Microsoft excel, learn excel, how to use excel, excel basics, basic excel, ms excel, office 365, excel for dummies, excel functions, learn excel basics, microsoft excel for beginners, excel course, Mr Excel, excel help, microsoft excel tutorial, excel tricks, excel tips, excel guide, how to in excel, tricks in excel, tips and tricks, pivots tables, excel formulas, advanced techniques for excel.

#Excel #MsExcel #ExcelMacro

[omnipop]

Thanks for this lesson. Is there a way to make Excel play a short video or to display a small picture at various times of day, or at one certain time every day (assuming the workbook is open)? (Example: At 5:00 PM every day, show a short 10 second video of someone doing a task which needs to be done at that time.) Thanks for any help on it.

[appsleek]

Thank you for taking your time to do this video, but I still have a challenge implementing it. Is there a way I can contact you directly so I explain in details the challenge?