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

[@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 👉 kzbin.info/www/bejne/oKjbgoeJe9WNnq8

[@markhuang368]

Thank you.

[@EXCELWIZARDINMINUTES]

Welcome Mark! 😊