How Do I Reset Timer in Excel 2007

Asked By 10 points N/A Posted on -
qa-featured

Whenever I'm in the office, I usually work with MS Excel 2007. I have this timer in my Excel using VBA. It works fine as it was counting properly. But, how do I reset timer in Excel? 

SHARE
Answered By 0 points N/A #132699

How Do I Reset Timer in Excel 2007

qa-featured

 

Good day Jabez!

I have been using Visual Basic for my timer as well and Just a thought if there is any chance that you also use an integer variable within the timer code that you have and it increases and decreases with every loop of the timer?

If so, then what you have to do is, Let us say your interval is 1000ms. After disabling the timer you have to set your interval into 0 and then reset again the interval to 1000 when you enable your timer.

I know Visual Basic is quite complicated so I wish that I could see what codes you used. Best of Luck!

Related Questions