timer and countdown

[k1dr0ck]

hi,

how do you create a timer
in sheet1 there is a start and stop button
when you click the start button timer starts counting visually
with a format of Xh Xm Xs in A1
when you click the stop button the value of Xh Xm Xs gets saved in A2

when you click the start button again it starts again at 1s
then when you click the stop button the value of Xh Xm Xs gets saved in A3

and so on


in sheet2 input a hour-min-sec value in A1
or (hour in A1, min in B1, sec in C1)
then clicking a start button
the countdown will start
then display a msgbox after the countdown is over
for example: when you type 5sec
after clicking the start button
it will countdown visually from 5 to 1 sec

[karedog]

Code on Sheet1 :

Please Login or Register  to view this content.

Code on Sheet2 :

Please Login or Register  to view this content.

Code on Module1 :

Please Login or Register  to view this content.

[k1dr0ck]

hi,

thanks, works great!
in sheet1 after clicking stop button how do i make it save the time starting at A3, A4, A5 and so on instead
and not on B1, C1, D1 and so on

[karedog]

You are welcome, thanks for rep.points.

Please change the code of this sub :

Please Login or Register  to view this content.

[k1dr0ck]

thanks again!

[karedog]

You are welcome, glad to help.

Regards