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.
Download Link: mega.nz/file/q...
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

[@omnipop4936]

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.

[@EXCELWIZARDINMINUTES]

@omnipop4936 yes it is possible. I have to create a userform and open it using the timer. In this userform, u have to put a media player as a button (the same way u have buttons, text, etc...). Here is a sample code at form initialization (hopefully it will kick start ur reasearch to make it work):
Private Sub UserForm_Initialize()
' Path to the video file
Dim videoPath As String
videoPath = "C:\Path\To\Your\Video.mp4" ' Change this to your video file path
' Set the URL of the Windows Media Player control
Me.WindowsMediaPlayer1.URL = videoPath
' Play the video
Me.WindowsMediaPlayer1.Controls.play
End Sub

[@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?

[@EXCELWIZARDINMINUTES]

Unfortunately, I just teach concepts to be applied on projects. In this case, I advise you to get pro help. Sorry for not being more helpful.

[@appsleek]

@@EXCELWIZARDINMINUTES Please this is the detailed information of the challenge 👉 ruclips.net/video/jwxQTSFpZhM/видео.html

[@markhuang368]

Thank you.

[@EXCELWIZARDINMINUTES]

Welcome Mark! 😊