Timer in Excel VBA 

Thanks for your valuable feedback

Thanks

Thanks for your valuable feedback

Thanks for your valuable feedback

Thanks for your valuable feedback

Thanks for your valuable feedback

Thanks for your valuable feedback

Did you get a solution to this?

​@@Premiercoaching I know that your comment or your question is two years old. I am a hobby VB Excel programmer and I just came across the video. The process should be changed a bit: 1. In cell P5 a new value (optional): "Total time:" 2. Cell Q5 receives the number zero (the total time value). 3. Cell D7 no longer has to refer to the difference time but to the total time cell: =if( q5=0; Q4; Q4+Q5) (this formula will check, if the overall time sum is 0; if true use the current difference time at first run, otherwise use difference time and add overall time) I don't tried this directly in Excel, so please be patient if any error occurs :) 4. The start macro must first be updated with the start time and now information like in the video shown. 5. The stop macro must also be adjusted. When you press stop, the GoTo loop must be ended (which it currently does). Then the current difference time (Q4) must be added to the total time (Q5). To do this, it makes sense to use a variable in the macro. After that, cell Q2 can be zeroed in this context (if you don't want to do this in the start macro), like: cells(5,17).value = cells(5,17).value + cells(4,17).value 6. In the reset macro the cells Q2 to Q5 are given the number zero, since we have to represent a time format, maybe like this one (first you have to dim the MySubTimer Variable as an integer): For MySubTimer = 2 To 5 Cells(MySubTimer, 17).Value = 0 Next MySubTimer Also all modules should take use of "option explicit", when you're using variables in your macro. Maybe this helps someone.

Good question! I will try to create a video on this topic.

will try to create a saperate video on this topic

Great suggestion! I will try to create a video on this topic.

Welcome

I dont mean to be so off topic but does anyone know a trick to get back into an instagram account..? I stupidly lost my password. I would love any assistance you can offer me.

@Arlo Blaze Instablaster ;)

@Ty Reign thanks so much for your reply. I found the site thru google and Im trying it out now. I see it takes quite some time so I will get back to you later with my results.

@Ty Reign it worked and I finally got access to my account again. I'm so happy! Thank you so much, you saved my account !

@Arlo Blaze you are welcome :D

Thanks for your valuable feedback

Obrigado por assistir o vídeo e compartilhar seus valiosos comentários. Compartilhe os vídeos com seus amigos e colegas.

Thanks for your valuable feedback. Yes we can create timer without macro but We can not show the live change without macro or need to press F9 to see the counter

I'm using multipage with same format userform, I create timer button in textbox I have already a timer But my problem is when I start timer button the timer start in pages 1 but when I'd tried to open other page and another timer start button,automatically the timer in page 1 stop, please help me continue the timer even i select another timer button

Thanks

Thanks

Your macro may be removed from that button Reassign stop macro in stop button...

Thanks

Thanks for watching