Excel Simple Digital Clock Timer VBA Macro

And for other Excel VBA learning resources and applications visit any of the other blogs of the Excel Macro Mania saga:

Soundtrack: Funk Le Nuit (dmusic studio)

[aymanali]

Hi, very nice video but i have a question can u make multiple digital clock timer in the same sheet because i've tried and i can't make it work, thanks.

[josephdaquila]

For everyone's reference you could just as easily write the code in more of the (r, c) syntax


i.e.

Cells(2, 2).Value = Cells(2, 2).Value + TimeValue("00:00:01")

instead of

Range("B2").Value = Range("B2") + TimeValue("00:00:01")

and so forth

[Ribeanie]

how would you do this in powerpoint? can anyone point me to a good tutorial? thank you

[tusharpal]

It was too easy to understand, thank you sir 😊

[RoshanHegde-zk]

Thanks for the video, whether the start timer and stop timer button can be triggered from userform activex buttons or only on excel spreadsheet becuase movetimer is not working from userform it throws an error !!!

[surayakanizsumona]

In that case how can we disabled the stop or reset button? I mean before I click the start button, the stop or reset button will be disabled and when we click the start button, it will immediately grey out and other buttons will be enabled. And vice versa.

[aymanali]

When i hide the excel page or lunch another programme the timer stops how can i fix it ?
And how can i save the models because every time i colse and open the excel i have to redo it all again i want to save it and when i open it again i can start working with the timer immediately

[markevananiel]

I hope you can make a tutorial wherein there is a time in time out feature and then it computes for the time lapsed. All this triggered by clicking and not by keyboard shortcuts.

[surontube]

Its running on other workbooks and sheets and throwing error on type mismatch. How to write an if condition to run only for a specific workbook ?

[adriandelosreyes]

Hi sir, may i ask i have encounter an error about mismatch when i open another workbook.

[michaelbowen]

I keep getting an error that the excel macro MoveTimer cannot be run, either because the macro is not available or all macros may be disabled. It runs other macros, but seems to be getting stuck on the Application.OnTime function. Any ideas?

[mokkelb]

Good video! Is there a way to add milliseconds?

[মোঃসোহেলরেজা]

Working between worksheets with the timer on turns the timer off. solution please

[MrPaunty]

Its Slow, i mean performance lag is there