Userform Count down timer do not run as it should when run for second time

**haripopuri** · 11-02-2012, 02:03 PM

Hi Forum Experts,

I am facing this strange problem while designing an exam test form. I allow users to complete test in maximum 10 minutes so I coded a count down timer of 10 minute using Application.Ontime method. It works fine. However it continue execution even if userform is unloaded (when user submits the test or cancel). On running the form for second time, count down starts from point when earlier form was unloaded but now with double the speed of ticking.
Can timer function (any function for that matter) be stopped from submit button click event?
Please help in fixing this. Thanks in advance for all the help.

**davesexcel** · 11-03-2012, 10:23 AM

Somehow MaxTime needs t be set to zero.

Possibly...

Please Login or Register  to view this content.

**haripopuri** · 11-03-2012, 10:43 AM

Hi Dave,

Thanks for the reply. Tried setting all the values to zero including MaxTime. Timer still runs in the background after unloading the form and with double the speed on next initiation.

**jaslake** · 11-03-2012, 12:45 PM

Hi hairpopuri

Your code doesn't stop the Timer...try the code in the attached. Let me know of issues.

**haripopuri** · 11-03-2012, 01:22 PM

Hi John,

Thank you. Its working perfect. Meanwhile I also tried stopping timer with a Boolean variable flag and it worked too. Attached here as reference for any one who want another work around.