Create A Live Clock In Any PowerPoint Presentation (No Flash!)

Тәжірибелік нұсқаулар және стиль

Discover how to embed a live, fully-customisable clock into any PowerPoint presentation, with no plugins required.
After my previous video a couple of years ago showing how to add a Flash clock to PowerPoint I looked into how to do the same thing but without using any plugin, and giving the user 100% control over the look and style of the clock. This is the result.
In this tutorial I'll show you how easy it is to build and embed a working digital clock into any slide of any presentation, with just a few simple lines of code.
As ever, I walk you easily through every single step, and the demo file is available to all Patreon supporters.
Timestamps:
3:15 Creating & naming a text box in PowerPoint
6:12 Enabling the Developer toolbar in PowerPoint
7:01 Inserting a VBA module in PowerPoint
7:33 Writing the code for a live PowerPoint clock
9:45 Making PowerPoint pause using code
12:43 Adding the code to start a live clock in PowerPoint
15:01 Formatting the displayed time in PowerPoint
24:04 Making code run when triggered by a change of slide
27:19 Making code run when you exit a PowerPoint slideshow
27:46 Saving a PowerPoint file that includes VBA code
30:38 Customising the appearance of a live clock in a PowerPoint slide
33:08 How to download a live clock in PowerPoint

Пікірлер: 372

  • @brucewan2292
    @brucewan22924 жыл бұрын

    Great tutorial! For those who are not familiar with VB script, copy and paste the following lines to the VB application: Public clock As Boolean Public currenttime, currentday As String Sub Pause() Dim PauseTime, Start PauseTime = 1 Start = Timer Do While Timer DoEvents Loop End Sub Sub StartClock() clock = Time Do Until clock = False On Error Resume Next currenttime = Format((Now()), "hh:mm:ss AM/PM") currenttime = Mid(currenttime, 1, Len(currenttime) - 3) ActivePresentation.Slides(SlideShowWindows(1).View.CurrentShowPosition).Shapes("shpClock").TextFrame.TextRange.Text = currenttime Pause Loop End Sub Sub OnSlideShowPageChange(ByVal objWindow As SlideShowWindow) clock = Flase ActivePresentation.Slides(SlideShowWindows(1).View.CurrentShowPosition).Shapes("shpClock").TextFrame.TextRange.Text = "--:--:--" End Sub Sub OnSlideShowPageTerminate() clock = False End Sub

  • @JorgePrates

    @JorgePrates

    3 жыл бұрын

    what is currentday for ?

  • @JorgePrates

    @JorgePrates

    3 жыл бұрын

    clock = Time -> clock = True clock = Flase -> clock = False

  • @ionebarros9778
    @ionebarros97784 жыл бұрын

    Awesome! I followed your instructions and the clock is working perfectly on my PPT presentations. :)

  • @transportfan08
    @transportfan084 жыл бұрын

    *OMG THANK YOU SO MUCH! I'VE BEEN TRYING THIS FOREVER!!*

  • @lauraallison1012
    @lauraallison10124 жыл бұрын

    Awesome tutorial - exactly what I was looking for. Thank you!

  • @chickenfish5274
    @chickenfish52744 жыл бұрын

    I am clearly going to be the coolest teacher (biggest nerd) in the school now with my timer and my clock in slide shows! Thanks! So helpful!

  • @TheTechTrain

    @TheTechTrain

    4 жыл бұрын

    I'm so glad you liked it ChickenFish

  • @janettaylor
    @janettaylor2 ай бұрын

    AMAZING! It does exactly what I wanted. I've never coded before and you made it super easy. Thank you!

  • @TheTechTrain

    @TheTechTrain

    2 ай бұрын

    I'm so glad it worked for you, and that you enjoyed it! 😊

  • @chobitsconspiracy
    @chobitsconspiracy8 ай бұрын

    I woke up today having never coded anything. I am ending my day with a clock in my teaching slides. (Canadian: We don't use the word Faff, but I know it from watching enough British youtube content. It is an excellent word and I've started adopting it). Your explanation was clear, concise, and I was able to troubleshoot and edit to my heart's content (I didn't need the seconds appearing on the slide). Thanks so much!

  • @louiseshedden3326
    @louiseshedden3326 Жыл бұрын

    I have never coded anything - but I managed this, few oops moments. Thank you! Was desperately trying to show time on a PowerPoint for my students! YOU ARE AWESOME.

  • @JuliArvi
    @JuliArvi4 жыл бұрын

    Thank you! This works so well for my college's information hub!

  • @terencepepper665
    @terencepepper6653 жыл бұрын

    Excellent presentation - clear and at the right speed.

  • @jproppecollege6082
    @jproppecollege60823 жыл бұрын

    Incredible! Thank you so much. You are an incredible instructor :-)

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    Thank you very much! That's very kind of you to say so. I'm so glad you liked the video.

  • @bmack94536
    @bmack945362 жыл бұрын

    Huge help for my presentations. Thank you!

  • @Salassquared
    @Salassquared4 жыл бұрын

    Thanks for the tutorial, it is clear, easy, awesome.....! You are the man.

  • @ederscience7537
    @ederscience75373 жыл бұрын

    That is just what I needed. I used to use a flash clock until they no longer supported it. This will be a lifesaver!

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    I'm glad it helped

  • @AndyVinson
    @AndyVinson2 жыл бұрын

    Very very informative! Love the explanations for every piece.

  • @danicadupreez2728
    @danicadupreez2728 Жыл бұрын

    Wow, thank you as a teacher with limited funds this has really made a difference! Thank YOU!!!!!!!!!!

  • @TheTechTrain

    @TheTechTrain

    Жыл бұрын

    I'm so glad to be able to help! If you need a low budget, DIY resource, please let me know - I welcome ideas and challenges to add to the channel!

  • @taufikhidayatnad
    @taufikhidayatnad3 жыл бұрын

    This is save my life. I was asked to put clock on ppt slides for a zoom meeting, so people from different time zone aware of time. I went through several matsclock for ppt video tutorial, but unfortunately it is not working anymore with the absence of flash player. I have no basic in writing coding, but I have to do since there is no other option than using macro. After correcting some typos that made the macro did not run, Finally, I made it. It shows in my ppt slide. Thanks The Tech Train.

  • @danishrehman240
    @danishrehman2404 жыл бұрын

    Hi, Thanks for sharing the video it helped a lot to unlock my clock. I further checked on internet and managed to use (almost) continuous clock by assigning the action "MouseOver" to some major objects on my presentation slides

  • @RaxLakhani

    @RaxLakhani

    3 жыл бұрын

    That's a genius workaround! So, you could, for example, insert a giant transparent rectangle in the foreground of the slide and insert the mouseover action to run the macro? Any slight movement would update with current time. I guess with this solution, the step at 26:17 can be removed?

  • @ErikEinum
    @ErikEinum2 жыл бұрын

    Thank you! I hardly ever log in to like or comment on YT, but this tutorial deserved both.

  • @TheTechTrain

    @TheTechTrain

    2 жыл бұрын

    Thank you so much! I'm very glad you enjoyed it. 😊

  • @JR-tv3dv
    @JR-tv3dv Жыл бұрын

    Very helpful tutorial - I am familiar with VB, so could have sped up a bit when discussing the program, but I appreciate that the audience is diverse and the explanations are nice and clear. Still amazed that there is no clock/timer functions as default within Powerpoint....

  • @joestevens66
    @joestevens663 жыл бұрын

    Absolutely brilliant, my friend: worked like a dream. Heck, there was no faff either!

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    I'm so glad you liked it joestevens66

  • @trumpet5565
    @trumpet55653 жыл бұрын

    This was so very helpful! Thank you - thank you - thank you. Your comments and instruction were very easy to follow. I manage a civic center for the community. This will look great on the screens.

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    Glad it was helpful!

  • @kgbadariprasad1
    @kgbadariprasad13 жыл бұрын

    Cool tutorial. Other than official presentations (where the template limits the experiments on the fonts, I concur with you on the challenge to find the right font for the presentations.

  • @prophetwayne9397
    @prophetwayne93974 жыл бұрын

    Thank you Sir. What you have showed me was extremely helpful and I appreciate the time you took to make this video. I will be using this as a timer in church to show real time as we go into the year 2020 and I will also be using it for other services

  • @TheTechTrain

    @TheTechTrain

    4 жыл бұрын

    I'm so glad you like it, and I hope it works well for you for your New Year celebration. Happy 2020!

  • @prophetwayne9397

    @prophetwayne9397

    4 жыл бұрын

    Thank you Sir God Bless. Iv liked, subscribed and shared your video and will definitely start following you. Your content will be extremely useful for me

  • @transportfan08

    @transportfan08

    4 жыл бұрын

    @@TheTechTrain I'm using this and I love it, *BUT* I need to add a custom countdown timer like this with NO FLASH. The videos on how to do this use youtube videos, make you pay EXTREME amounts of money for a software *subscription* OR use animations and only count down from 5 or 10. If you could make a video like this on *but a countdown timer* I would really appreciate it. Regards, Conor.

  • @steveevans7307
    @steveevans73073 жыл бұрын

    Well Done! Heck ya! (yes, we use that term...ya gotta watch the video!) You are a very talented teacher. I had one small typo so I had to debugg to find it. Purely my fault, though, your video was terrific. I'll be back!

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    Heck, what a great comment! Thank you so much, and very glad you liked it.

  • @rusticcynic
    @rusticcynic3 жыл бұрын

    Excellent tutorial, thank you!

  • @palmbeachaircraftpropeller5340
    @palmbeachaircraftpropeller53404 жыл бұрын

    Thank you for this solution. I is nearly complete for me. I need to work on getting the clock to activate automatically rather than click on it but I'll do that soon. With regard to faffy/faffie etc. In the US, I've used Wiggy. This is when something is a bit 'weird' in its action or implementation. Heck... well that it the polite word. Dang, and other not so polite words can be used in its place but heck works well.

  • @deeparanganathan361
    @deeparanganathan3613 жыл бұрын

    Thank you so much.It is very helpful.step by step explantion very nice

  • @brandigore8820
    @brandigore88206 ай бұрын

    Wow! Thank you very much! This was really cool to learn!

  • @woodythdog
    @woodythdog3 жыл бұрын

    Thanks for this Awesome tutorial , I used it to add a clock to the waiting room Slide for my online class, the only tweak I made was changing the " --:--:-- " to "START"

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    Glad it helped!

  • @timgordon229
    @timgordon2293 жыл бұрын

    Really excellent - very clear instructions. One thing that I might add into this, would be how to recycle the same macro into other PPT files. Many thanks again,

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    I'm so glad you found it useful, thanks.

  • @user-sm4mc8ox5c
    @user-sm4mc8ox5c2 жыл бұрын

    This is it ! Thank you very much.

  • @XethIsDefinitelyCool
    @XethIsDefinitelyCool3 жыл бұрын

    Thank you for helping me because I need it for the PowerPoint os.👍😇

  • @Nitpickerman
    @Nitpickerman3 жыл бұрын

    Thanks for this tip. Since I did not like when the letters in fonts have different width the output moves a bit when the clock runs. I modified this so that everyletter as well as the colon-texts were own ones. Now the placing is not changing even though showing numbers of different width. I will also make an other modification, that is to be used for short breaks. But thumbs up for this code snip.

  • @gaurav.anirbandutta

    @gaurav.anirbandutta

    2 жыл бұрын

    Share the code please

  • @chandellesimplestaging
    @chandellesimplestaging Жыл бұрын

    Thank you so much this was great!

  • @janetmagday5469
    @janetmagday54696 ай бұрын

    Thank you for this! Choosing the font does take time. Hoping to see how to make a timer that you can set for a certain period of time for breaks.

  • @leevanrensburg2139
    @leevanrensburg21394 жыл бұрын

    Excellent teacher thank you

  • @natashaabrahams9251
    @natashaabrahams92513 жыл бұрын

    Thank you so much for your guidance! I don't know code, and your step by step explanation made me a winner! Thank you!

  • @natashaabrahams9251

    @natashaabrahams9251

    3 жыл бұрын

    Is there any way I could embed or copy this clock into Google Slides? Or is that a different code?

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    I'm so glad you found it useful!

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    I'm afraid that Google Slides uses a completely different coding language, so this couldn't just be copied across. I may look at covering Google coding at some point in the future.

  • @natashaabrahams9251

    @natashaabrahams9251

    3 жыл бұрын

    @@TheTechTrain Thanks so much!

  • @scarpien

    @scarpien

    3 жыл бұрын

    @@TheTechTrain Please do. I have the same concern. I guess in the meantime I'll create a powerpoint of my classroom scene.

  • @MarkOldfield-jm5no
    @MarkOldfield-jm5noАй бұрын

    Fantastic - great Job.

  • @TheTechTrain

    @TheTechTrain

    Ай бұрын

    Many thanks!

  • @adamsleong
    @adamsleong2 жыл бұрын

    Thanks this tutorial video! Help me a lot.

  • @kulbirsg84
    @kulbirsg843 жыл бұрын

    Excellent tutorial, thanks a lot, how can I Start the clock automatically on the slide load? thanks for letting me know

  • @mrsuliban
    @mrsulibanАй бұрын

    thank you for teaching us. 🙂

  • @TheTechTrain

    @TheTechTrain

    Ай бұрын

    My pleasure 😊

  • @Misterholas
    @Misterholas3 жыл бұрын

    Thanks very much for a very carefully put together tutorial, you are a talented teacher. I am on Mac atm (my home machine) so had to add the VB add-in from Bright Carbon to follow tutorial. No problem with code on the face of it having debugged it. But the clock will not display on mouse click. I am guessing this is to do with the proper name for system time in OSX not being the same in Windows. If anyone has any insight on how to pull system time into this code on a Mac I would be very grateful. In the meantime off for more coffee and some research.

  • @Den_G69
    @Den_G693 жыл бұрын

    Thank you very much, very helpful!

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    You're very welcome, I'm so glad.

  • @mustadxb09
    @mustadxb09 Жыл бұрын

    Cool and great Pedagogy!

  • @amandajackson284
    @amandajackson28411 ай бұрын

    Thank you so much! In the south US, we say "Finicky" and we say "Heck."

  • @wmgmiller4
    @wmgmiller42 жыл бұрын

    This was awesome! Great detail and explanation THANK YOU! Do you have a code that will do a countdown timer similar to this?

  • @RosnerTheWriter
    @RosnerTheWriter6 ай бұрын

    Yay! I did it!! The Timer/Clock function on the Promeathan Board at work does not show the clock or timer. With this embedded clock, the students can tell the time during their NYS ELA Regents exams. Thanks!

  • @KimberlyAlesnaFano
    @KimberlyAlesnaFano3 ай бұрын

    excellent! it works!

  • @TheTechTrain

    @TheTechTrain

    2 ай бұрын

    Glad it helped!

  • @rhenginal3699
    @rhenginal3699 Жыл бұрын

    Loved this video! Super helpful. I am a teacher as well, and having the time displayed on my slides is often something I desperately need. It seems like there should be a built-in live clock, or at least an ad-in, but I couldn't find one anywhere! Something I loved about this tutorial was that it wasn't just an explanation of how to do it, but also why you need every part and what each code line does. I feel like I learned a lot more than just how to insert a live clock into my slide show. I was wonder, though, is there a way to make it so that the clock is just constantly running on every slide? Having to click the text box in order to start the clock can be a little tedious. I really just want a constant live clock in the bottom corner of my slide show so that my students never have to ask me what time it is, or use that as an excuse to pull out their phones. I tried to just ad another bit of code that says to run the start clock subroutine on slide transition, but that didn't work at all. I don't know if I typed the code in wrong or if the idea just doesn't work, but I'd love to get this working. Thanks!

  • @Alexandros.Deligiannis
    @Alexandros.Deligiannis3 жыл бұрын

    Dude you are the best!!! Thanks a lot !!!

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    Thank you, so glad you like it!

  • @weasleyhead22
    @weasleyhead22 Жыл бұрын

    Hey Its Worked! The Code is working!

  • @sanjwij
    @sanjwij Жыл бұрын

    Amazing tutorial, thank you so much and thank you @Bruce Wan for the copy and paste! Just what I was looking for. Unfortunately it's not working for me and I dont know VBA so totally stuck! will have another look in the morning, can't figure out what i'm doing wrong. you are an amazing teacher, you're certainly in the right profession!

  • @sanjwij

    @sanjwij

    Жыл бұрын

    Hooray it's working, thank you so much! The time in underlined and I don't know how to undo that, but I'm so happy with it, will be using this for exams!

  • @TheTechTrain

    @TheTechTrain

    Жыл бұрын

    The time is probably underlined because you clicked on that, rather than the edge of the box it's in. Try clicking once inside the time so that you have a flashing vertical text cursor, then right click and select "Remove Hyperlink". I'm very glad it's working for you apart from that! 😊👍

  • @sandradunhill2418
    @sandradunhill24182 жыл бұрын

    Enjoyed the Tutorial very much. How would I make the time do a countdown? It's been awhile since I've used Visual Basic, so I'm relearning some of the commands. I have a project I'm working on now that my client wants a countdown timer to display while virtual meeting participants start joining the event and are waiting for it to start.

  • @jeremiah2829
    @jeremiah2829 Жыл бұрын

    Thanks so much!!!! I appreciate it!

  • @TheTechTrain

    @TheTechTrain

    Жыл бұрын

    You are so welcome!

  • @dgsmsideabytes2291
    @dgsmsideabytes22914 жыл бұрын

    I needed to make a timer for our toastmaster meetings - given that we are online now. Got the timer working was able to change screen color at different times. - all good. However when it came to terminate, I wanted to reset all the parameters - to no avail. Even on slide change the clock stops but I cant get it to change to --:-- Any thoughts?...

  • @BANEBRO2
    @BANEBRO24 жыл бұрын

    great content love this wish you have more subscribers

  • @NunoBispo
    @NunoBispo4 жыл бұрын

    Great! Thanks!

  • @teguhrahayusantoso2062
    @teguhrahayusantoso20624 жыл бұрын

    thank you for the learning very helpful for those of us who don't understand about implementing ppt coding I want to ask ... what if this watch was applied singly to the LED TV? not on a computer monitor, does it have to be converted first to video? then stored on a USB Flash Disk? and immediately displayed (plug and play) Thank you very useful hopefully it becomes a blessing

  • @GregPlotkin
    @GregPlotkin4 жыл бұрын

    Awesome! Thank you!

  • @TheTechTrain

    @TheTechTrain

    4 жыл бұрын

    You're very welcome!

  • @ChardLanceCasper
    @ChardLanceCasper3 жыл бұрын

    Thank you so much

  • @garytaylor6569
    @garytaylor65693 жыл бұрын

    Got it to work great even managed to make it show date and time, however when I click to activate it leaves me with a blue spinning mouse icon ! any ideas ?

  • @myhome138
    @myhome1383 жыл бұрын

    Thank you very much

  • @arnabgoswami4893
    @arnabgoswami48933 жыл бұрын

    Thank you for this. Can you please tell what to change in the code if I want to skip the start button?

  • @faisalmoghal4055
    @faisalmoghal40553 жыл бұрын

    Thanks so much. This is amazing, especially now that Microsoft have ANNOYINGLY removed flash support. One question: is there a way to change this to a 24 hour clock? UPDATE: managed to get it in 24-hour by using "Long Time" rather than hh:mm:ss in the format section. This uses you PC's time format

  • @RondenBreems
    @RondenBreems Жыл бұрын

    Great routine! Could it be possible to use an event like 'start presentation' or 'show slide x' to trigger the 'start clock' routine and a 'leave slide' event to trigger clock=false ???

  • @GaryWeak
    @GaryWeak Жыл бұрын

    Hi, Very nice tutorial, easy to follow. Worked perfectly first time. I am using the clock on one slide of a 2 slide presentation that I have running a loop continually at 30 second intervals. When I do this the clock stops when it gets back to the slide with the clock. Is there a setting I can change to fix this?

  • @hooralshehhi9770
    @hooralshehhi97702 жыл бұрын

    so hard but exactly what i was looking for

  • @cindyrothermel8461
    @cindyrothermel84614 жыл бұрын

    Would I be able to do code that rather than the clock on the computer that it would be count down?

  • @iitianforu
    @iitianforu4 жыл бұрын

    Thanks for the code. Can you please share code to turn it on automatically with change of slide in slideshow mode. I want to use it show current time.Thanks

  • @nica2446
    @nica24462 жыл бұрын

    Hello thank you for the great video. is there a way of starting the clock automatically?

  • @dronevluchten
    @dronevluchten3 жыл бұрын

    A great solution. Although you should also add a SUB for OnSlideShowTerminate otherwise VBA remains running. ANother problem is that both events OnSlideShow.... are deprecated and replaced by application events. And I get those not working....

  • @Kat21
    @Kat214 жыл бұрын

    how do i do this without clicking like automatically start on presentation

  • @mlissacaines3842
    @mlissacaines38423 жыл бұрын

    I am running a multi slide presentation on a loop. How do I have the clock current and running on each slide without me having to click on it each time?

  • @oxstrangelyrandomxo
    @oxstrangelyrandomxo3 жыл бұрын

    Love this thank you :)

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    I'm so glad!

  • @amandavankleeck2815

    @amandavankleeck2815

    2 жыл бұрын

    @@TheTechTrain I'm having issues- The code looks the same as yours, but when I put the action in, it turns the --:--:-- from a black font to a blue font, almost like it's a hyperlink? I have no idea what I did wrong.

  • @TsuziQMadeinTaiwan
    @TsuziQMadeinTaiwan3 жыл бұрын

    Do you have video on how to do a break countdown clock?

  • @sandhipatria1338
    @sandhipatria13383 жыл бұрын

    Thank You

  • @weasleyhead22
    @weasleyhead22 Жыл бұрын

    Ok i made a os with Macro and it worked!

  • @IvyPlans
    @IvyPlans Жыл бұрын

    Very helpful

  • @MrAbhishekjain29
    @MrAbhishekjain293 жыл бұрын

    This is an incredible tutorial. I would like the text box not to be clicked in the next slide even if it makes the computer slow. Is it possible to do so. I want the clock to look continuous. Clicking everytime is not a great idea. I hope you can help.

  • @yannickhautle
    @yannickhautle4 жыл бұрын

    does this work with apple keynote as well?

  • @TMXGroup
    @TMXGroup Жыл бұрын

    Nice tutorial, I just wonder if is possible to create a count-down real-time clock in powerpoint. do you have any video for that? thanks

  • @OfficialJohnnyNelson
    @OfficialJohnnyNelson Жыл бұрын

    Thanks for this, Justin. Huge help! Question: Is "currentday" needed in the string?

  • @Thehunter4332
    @Thehunter4332 Жыл бұрын

    Very useful! However when I add the action PowerPoint adds an underline to the text. Is there any way to get rid of the underline?

  • @mathewstw
    @mathewstw3 жыл бұрын

    How do I display UTC in PowerPoint using this method? Is it possible?

  • @Sss.ssS7766
    @Sss.ssS77662 жыл бұрын

    Thank you very much. This is awesome educate. May I ask you one struggle I found. My live clock as I following you every step. But my clock cant play automatically. Please kindly suggest. Thank you

  • @jewelcrystal
    @jewelcrystal3 жыл бұрын

    This is very useful now that Flash is dead. Would you be able to make a countdown timer for 1 hour via VBA code? that you can pause, resume and reset to an hour or reset to specific time? if possible?

  • @redzuone85
    @redzuone853 жыл бұрын

    you are awesome...terbaikk...

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    Thank you so much! I'm very glad you liked it.

  • @ELEISONCARABALLO
    @ELEISONCARABALLO Жыл бұрын

    Awesome presentation. I need a countdown timer, about 5 minutes time lets say. Can you help and tell what changes are to be made in code?

  • @StephenReidN
    @StephenReidN2 жыл бұрын

    Brilliant

  • @CnSLearningFacilitators
    @CnSLearningFacilitators Жыл бұрын

    Could you show how to put countdown timer throughout the PPt show

  • @MagnaLynx21
    @MagnaLynx213 жыл бұрын

    Comment for the algorithm, sales office managers will be a fan of yours ;)

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    All part of the service! Glad it helped.

  • @pyro1149
    @pyro11493 жыл бұрын

    Great Video! Worked flawlessly. One question; what is currentday for at the top of the code. Also, I'd like to add the current date either at the top of the clock or on a different text box above the clock. Would that be possible by adding another line with a date or today function inside the Startclock code? Many thanks!!!

  • @TheTechTrain

    @TheTechTrain

    3 жыл бұрын

    Yes, you can do this. Just change the 'StartClock' subroutine to this: Sub StartClock() clock = True Do Until clock = False On Error Resume Next currenttime = Format((Now()), "h:mm:ss AM/PM") currentday = Weekday(Now(), vbMonday) Dim lngWeekDay As Long: lngWeekDay = currentday Dim strWeekDayName As String strWeekDayName = WeekdayName(Weekday:=lngWeekDay, Abbreviate:=False, FirstDayOfWeek:=vbMonday) currenttime = Mid(currenttime, 1, Len(currenttime) - 3) 'includes seconds 'currenttime = Mid(currenttime, 1, Len(currenttime) - 6) 'no seconds ActivePresentation.Slides(SlideShowWindows(1).View.CurrentShowPosition).Shapes("shpClock").TextFrame.TextRange.Text = strWeekDayName & vbCrLf & currenttime Pause Loop End Sub

  • @robertrisacher4190
    @robertrisacher41909 ай бұрын

    I managed to make this work on my Mac and I'm very grateful for the help. What I really want to do, however, is have the clock on every slide in the presentation, automate the presentation and not have to "press the button" on individual slides. Could the VB be modified to auto start with the presentation and restart with each slide as it initializes?

  • @LearnerCB246
    @LearnerCB24611 ай бұрын

    how would modify your clock as a timer/ coundown? say if i was taking a 2 hour quiz - click start quiz timer starts.

  • @hiteshk3007
    @hiteshk30075 ай бұрын

    Thank you very much for telling the things so nicely that a person like me who is unfamiliar with VBA could also run the clock in powerpoint. The problem I am facing is that whenever I change slide I need to click the clock textbox in order to run it. Else it stops on changing the slide. How to fix it.

  • @TheKlali100
    @TheKlali100 Жыл бұрын

    Mr Tech Train I owe you my life

  • @MarisolRamos-1971
    @MarisolRamos-19714 жыл бұрын

    Excelente gracias :)

  • @TheTechTrain

    @TheTechTrain

    4 жыл бұрын

    You're very welcome!

  • @transportfan08

    @transportfan08

    4 жыл бұрын

    @@TheTechTrain I did every step and it did not work. When I start the slide and click on it nothing happens, outside the box it will change slides like normal so it is activated in some way

  • @angelalim7991
    @angelalim79913 жыл бұрын

    Hi. i did everything till 30:00 but the timer didn't appear.....Any idea why? Need this quite urgently....Thanks!

  • @willytichener
    @willytichener Жыл бұрын

    Hi, I followed your instructions but I only got a placeholder dashes and colons with a line underneath, where did I go wrong?

Келесі