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