How Do I Reset Timer in Excel 2007

Asked By jabez zion 10 points N/A Posted on - 12/08/2012

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? 

• Status: Open
• Question Views: 942
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Ywain Jamin 0 points N/A #132699

How Do I Reset Timer in Excel 2007

 

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!

About Ywain Jamin

Questions
2

Answers
30

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 12/11/2012
• Question Category: MS Excel