Countdown Timer Pause and Resume Button

Hey guys, I'm new so please forgive me for the simple questions that I'm coming up with. You are all helping me out so much and I apprecaite it very much.

I am trying to create a countdown timer my class. I want to give them an amount of time to discuss a certain topic then bring them all back together as a class to discuss what they talked about.

Anyway the start buttons work. I want to insert a button that will pause this (so the we can clarify something if needed) and then when I click start it will continue right where it left off.

Please Login or Register  to view this content.

Maybe like this.

Add three buttons from the Control Toolbox, and name them btnStart, btnPause, and btnResume. Then put this code in the Sheet module:

Please Login or Register  to view this content.

Then put this code in the Sheet module:

That's where it MUST go.

I know this is nothing big for a lot of you guys but I just got it counting down minutes and seconds! I'm proud of myself.

If I pause the code it will resume right where it left off. I just need a macro that will pause the code. How do I do it? It can't be that hard.

Please Login or Register  to view this content.