Пікірлер
@quechismoso
@quechismoso 2 ай бұрын
This video was so helpfull, but do you know how to make it start again it self?
@smitaaay
@smitaaay Жыл бұрын
Thank you, so much, for this video! Great job. 🙂🙂
@SouthLightFX
@SouthLightFX Жыл бұрын
Hi anameiwontforget Great video I must agree, but do you have the module code available as text/a file?
@ninjasapporo4850
@ninjasapporo4850 Жыл бұрын
The next thing I am wondering is how to pin it on top of windows system....
@ArnellLoïck
@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
@maherlearn Жыл бұрын
www.youtube.com/@maherlearn
@YatraShubh-MangalmayeHo
@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
@cassandranicolepallanan1643 Жыл бұрын
Hi may i ask how to add sound effect when 10 seconds before end of timer
@internetnetnet3834
@internetnetnet3834 Жыл бұрын
no esta nitido el video y no se pueden apreciar los codigos y es una lastima me servia muchisimo
@adilauliarn2852
@adilauliarn2852 Жыл бұрын
thank u sir my homework is finished
@eluszopirar
@eluszopirar 2 жыл бұрын
Hi sir. Can you combine this method with randbetween?
@stevemendoza4666
@stevemendoza4666 2 жыл бұрын
I would like to pay you for a custom timer please reach out thanks.
@sanjaybhosale6778
@sanjaybhosale6778 2 жыл бұрын
Thank you so much
@CoeyDien
@CoeyDien 2 жыл бұрын
Thanks so much. You are saving my life.
@VicPodcast
@VicPodcast 2 жыл бұрын
how would this be done on google sheets?
@piotrszymanski7071
@piotrszymanski7071 2 жыл бұрын
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.
@maggot95mustaine
@maggot95mustaine 3 жыл бұрын
So simply and easy tanks
@r4m1ng03
@r4m1ng03 4 жыл бұрын
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?
@FromBrooklyn2024
@FromBrooklyn2024 4 жыл бұрын
Would this work in Slide Show mode?
@vishnuvardhann2855
@vishnuvardhann2855 4 жыл бұрын
thank you very much
@irfnrdh
@irfnrdh 4 жыл бұрын
awesome, thanks !
@ajjudj7777
@ajjudj7777 4 жыл бұрын
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]
@anameiwontforget
@anameiwontforget 4 жыл бұрын
Look through comments for user Robbiedoss question. I replied in that thread with code that would help with your issue.
@Moriarity09
@Moriarity09 4 жыл бұрын
how can I bold the font and the change font size of the slide number using vba ?
@melissawhyman9690
@melissawhyman9690 4 жыл бұрын
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_tales
@Veer_tales 4 жыл бұрын
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
@ricro880
@ricro880 4 жыл бұрын
Thanks for this explanation. How do I get this timer to be active and visible in several worksheets in the same workbook
@guillaumechandonnet8225
@guillaumechandonnet8225 4 жыл бұрын
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
@TheCveau
@TheCveau 4 жыл бұрын
is it possible to add a beep at the end of the countdown?
@artesfotosservicosgraficos9238
@artesfotosservicosgraficos9238 5 жыл бұрын
@artesfotosservicosgraficos9238
@artesfotosservicosgraficos9238 5 жыл бұрын
vc poderia me manda esse cronometro por e-mail, por favo
@jwf3148
@jwf3148 5 жыл бұрын
Your video tutorial format and presentation is EXCELlent !!! Much appreciation for this clear and concise presentation.
@Kiyoshi_9606
@Kiyoshi_9606 5 жыл бұрын
Please redo this video. It'd be massively useful!
@deannac8639
@deannac8639 5 жыл бұрын
Great tutorial...Something I really needed for a project that I am working on. Thank you!
@ArnellLoïck
@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 ?
@nahidmukadam
@nahidmukadam 5 жыл бұрын
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
@dantecpa
@dantecpa 5 жыл бұрын
you are the best, thank you.
@Esclarecidos
@Esclarecidos 5 жыл бұрын
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?
@profitpark1737
@profitpark1737 5 жыл бұрын
cool
@visualcapricorn4479
@visualcapricorn4479 5 жыл бұрын
Cool bro!
@mlusbel
@mlusbel 5 жыл бұрын
It's amazing! Thanks a lot!
@rampager1016
@rampager1016 5 жыл бұрын
good job 👍
@mohannimmagadda3033
@mohannimmagadda3033 5 жыл бұрын
Code not visible Hero 🦸‍♂️
@sufyanomer7750
@sufyanomer7750 5 жыл бұрын
Thank you @anameiwontforget this is exactly what i was looking for !!!!!!
@fabiodesignen8365
@fabiodesignen8365 5 жыл бұрын
vc poderia me envia essa planilha pvf
@jkoppel1
@jkoppel1 5 жыл бұрын
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?
@anotherone4657
@anotherone4657 5 жыл бұрын
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_luz
@renato_luz 5 жыл бұрын
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!
@renato_luz
@renato_luz 5 жыл бұрын
drive.google.com/open?id=1CWLGzIHQY3g4N1V47Y3VW7bfSvlqS_2w
@renato_luz
@renato_luz 5 жыл бұрын
Thank you very much! I create a VBA file based on the video.. excel + power point drive.google.com/open?id=1CWLGzIHQY3g4N1V47Y3VW7bfSvlqS_2w
@moso0258
@moso0258 5 жыл бұрын
i want it to start with single button and when it became 0 it stops and became 45
@OrangeBossa
@OrangeBossa 5 жыл бұрын
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!
@MortenBN1988
@MortenBN1988 5 жыл бұрын
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.