This video was so helpfull, but do you know how to make it start again it self?
@smitaaay Жыл бұрын
Thank you, so much, for this video! Great job. 🙂🙂
@SouthLightFX Жыл бұрын
Hi anameiwontforget Great video I must agree, but do you have the module code available as text/a file?
@ninjasapporo4850 Жыл бұрын
The next thing I am wondering is how to pin it on top of windows system....
@ArnellLoïck Жыл бұрын
Is it possible to apply a timer to the Emails ? Say every 7 months for exemple it sends an Email. What would be the formula ?
@maherlearn Жыл бұрын
www.youtube.com/@maherlearn
@YatraShubh-MangalmayeHo Жыл бұрын
Sir I want to make a timmer eg if I have 24 hours left to complete one work and I would go to the sheet to look at the time each task how many hours are left . Can I make that one will run anti clock wise
@cassandranicolepallanan1643 Жыл бұрын
Hi may i ask how to add sound effect when 10 seconds before end of timer
@internetnetnet3834 Жыл бұрын
no esta nitido el video y no se pueden apreciar los codigos y es una lastima me servia muchisimo
@adilauliarn2852 Жыл бұрын
thank u sir my homework is finished
@eluszopirar2 жыл бұрын
Hi sir. Can you combine this method with randbetween?
@stevemendoza46662 жыл бұрын
I would like to pay you for a custom timer please reach out thanks.
@sanjaybhosale67782 жыл бұрын
Thank you so much
@CoeyDien2 жыл бұрын
Thanks so much. You are saving my life.
@VicPodcast2 жыл бұрын
how would this be done on google sheets?
@piotrszymanski70712 жыл бұрын
Hi will it work for multiple rows in excel? I creating spreadsheet with multiple tasks on it and wants countdown time for each one. BTW thanks for video.
@maggot95mustaine3 жыл бұрын
So simply and easy tanks
@r4m1ng034 жыл бұрын
Good. Exactly what I was looking for.. the problem is that o Mac if I start the timer and then I select another application to do something else, the timer gets frozen. It will continue only if I select excel window again.. any idea?
@FromBrooklyn20244 жыл бұрын
Would this work in Slide Show mode?
@vishnuvardhann28554 жыл бұрын
thank you very much
@irfnrdh4 жыл бұрын
awesome, thanks !
@ajjudj77774 жыл бұрын
HI, I used your code to create a Time and is running fine .I used to create a process exam for 15 mins But i have a drop down list which has option A,B,C,D. When user clicks the drop down the timer stop temporarily unless user selects the option . The timer resumes from where it stopped say user clicked the drop down at 00:14:10 then unless the user selects the option the timer is stuck at 00:14:10 Do you know the solution on this. A bit urgent ??? Email - [email protected]
@anameiwontforget4 жыл бұрын
Look through comments for user Robbiedoss question. I replied in that thread with code that would help with your issue.
@Moriarity094 жыл бұрын
how can I bold the font and the change font size of the slide number using vba ?
@melissawhyman96904 жыл бұрын
This is fantastic. Thank you!Is there a way to set the start timer to then open a text box for writing and when the timer is done to close it? I am a teacher trying to figure out a way to set up a 3 minute timed writing. This is the closest I have gotten to what I want. Thanks!
@Veer_tales4 жыл бұрын
I have made an exam in excel and set this count down timer but it pauses when i access other cells for typing.. any solution
@ricro8804 жыл бұрын
Thanks for this explanation. How do I get this timer to be active and visible in several worksheets in the same workbook
@guillaumechandonnet82254 жыл бұрын
Very helpful tutorial! Is there a way to expand that to every shape in my ppt, not only the selected one? For the part "get data, and then à could just delete the ones i dont want? That way i could just do it once
@TheCveau4 жыл бұрын
is it possible to add a beep at the end of the countdown?
vc poderia me manda esse cronometro por e-mail, por favo
@jwf31485 жыл бұрын
Your video tutorial format and presentation is EXCELlent !!! Much appreciation for this clear and concise presentation.
@Kiyoshi_96065 жыл бұрын
Please redo this video. It'd be massively useful!
@deannac86395 жыл бұрын
Great tutorial...Something I really needed for a project that I am working on. Thank you!
@ArnellLoïck Жыл бұрын
Is it possible to apply a timer to the Emails ? Say every 7 months for exemple it sends an Email. What would be the formula ?
@nahidmukadam5 жыл бұрын
first of all i would like to thank you for your information to help me to completing my project. but i do find some problem as like 1)if timer is on and if i do want to type in another cell the timer is been stop. 2)and when timer is complete it delete the formula from the reference cell as like cell "C:6" IS my number value (for example:- 90) and cell "P:3" has formula of =DOLLARED(C6,60)/1440 With format of time"00:00:00" so that if i type 90 in cell(C:6) it convert with the formula and show value (01:30:00) in "P:3" and ''P:3" is the reference to my text box
@dantecpa5 жыл бұрын
you are the best, thank you.
@Esclarecidos5 жыл бұрын
Do you know how to control a video in a slide with buttons? I inserted some bookmarks on the video, and I want the buttons to start playing the video at bookmarks times. For example, button 3 starts bookmark 3, button 4 starts bookmark 4, etc. I couldn't find out a way to do that using normal Powerpoint actions. Maybe with VBA it is possible. What do you think?
@profitpark17375 жыл бұрын
cool
@visualcapricorn44795 жыл бұрын
Cool bro!
@mlusbel5 жыл бұрын
It's amazing! Thanks a lot!
@rampager10165 жыл бұрын
good job 👍
@mohannimmagadda30335 жыл бұрын
Code not visible Hero 🦸♂️
@sufyanomer77505 жыл бұрын
Thank you @anameiwontforget this is exactly what i was looking for !!!!!!
@fabiodesignen83655 жыл бұрын
vc poderia me envia essa planilha pvf
@jkoppel15 жыл бұрын
I created a timer exactly as in the video with the exception of the time to begin the countdown. Sheet1.Range("B1").Value is a string variant and is an integer variant, causing a type mismatch error. 1. Why does it work in the video but not on my desktop and 2. how do I resolve this?
@anotherone46575 жыл бұрын
Hi Can it it me user wise data? Like if I am using it and used 2 min so it can track 2 min and the other user can see who has how much time.
@renato_luz5 жыл бұрын
i'm creating a virtual exam (like CFA mock tests).... i already have a question bank in excel i'm trying to improve the text boxes layout, since i have simple alternative questions(a, b, c, d) but i also have sufficient questions I - sentence I II - sentence II III - sentence III a) only I b) I & III c) II & III d) I, II & III i need to know how to adjust the size of the text box, depending the size of the text. if anoyone could help, i'd be very happy!
Thank you very much! I create a VBA file based on the video.. excel + power point drive.google.com/open?id=1CWLGzIHQY3g4N1V47Y3VW7bfSvlqS_2w
@moso02585 жыл бұрын
i want it to start with single button and when it became 0 it stops and became 45
@OrangeBossa5 жыл бұрын
Why do you use ActiveX buttons instead of assigning Subs directly to Form Control buttons? And why the countdown jumps so fast every time you clicked start? Like from 4:59 to 4:58. Thanks!
@MortenBN19885 жыл бұрын
The countdown can jump the first second depending on the system time. This is caused because this timer works by counting one second down for each second the system time has counted one second forward. In the "starttimer" Sub you can see that the "nexttick" Sub is initiated every time the system time is at its current time (Now) + 1 second. With this method the first second in the countdown will always be shorter than an actual second as there's already a second in progress when you press the button. Hope you understand.