Switching sheets while timer running

This is the code written in the sheet called "Safety Injection":

Please Login or Register  to view this content.

This is the code written in the standard code module:

Please Login or Register  to view this content.

Timer is malfunctioning when I try to switch between sheets. I have data
that goes into sheet called "Pressure". This data causes "Q35" on "Safety
Injection" to become either a 1 or a 0. When I manually change the data in
the "Pressure Sheet" to make "Q35" = 1, the timer in "Safety Injection" should starting counting down from 30 to 0. Timer sometimes freezes or it sometimes it starts counting down by 2's.

However, when I stay on "Safety Injection" and take out the formula in "Q35" and just put a 1, the timer functions properly.

Help please...Thanks

Hi Doug. Your code, as is, allows simultaneous calls to the OnTime method. This would explain the jumps in decrement of nCount. See the edit below that is based upon my understanding of what you are looking for. If not, let me know...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks for your reply...I will not be able to apply your code until Monday, but I will be sure to let you know how it goes.

You are my savior