Hi , I have made a user form "Userform 1" where I have a button to Pull up "UserForm 2" which is basically a timer display with a lable box to show time elapsed and a command button to stop the timer.
Users are required to STOP the timer when they are back from break. I just need to know how to auto start the timer code on "userform 2" as soon it is opened .i.e the code to lable box should run automatically.
The other option I can think of is to display timer on "Userform 1" itself ,but problem I have is that timer is not stopping when User clicks on desired command button to stop the time(The same command button is also used to add the records made by users)
Users are required to STOP the timer when they are back from break. I just need to know how to auto start the timer code on "userform 2" as soon it is opened .i.e the code to lable box should run automatically.
The other option I can think of is to display timer on "Userform 1" itself ,but problem I have is that timer is not stopping when User clicks on desired command button to stop the time(The same command button is also used to add the records made by users)
Last edited:
