VBA for multiple countdowns, print times, then exit without saving

[kennethbass]

Hello all!

I have worked for 2 days on this issue and I am barely half way there.

Untitled.jpg

The time is the counting down total time allowed for all phases of the activity. I need it to start on open and only have a stop/pause button. I also need the Target Time cells to count down once the main timer starts. So when the file is opened, the overall countdown begins then cell C2 will countdown to 0 and stop, the cell C4 will countdown to 0 then stop and so on.

Here is my main timer code:

Please Login or Register  to view this content.

Is this at all possible!?

[LJMetzger]

Hi kennethbass and welcome to ExcelForum,

See the file associated with post #4 in the following thread: http://www.excelforum.com/excel-prog...wn-timers.html

The file uses code similar to yours to time multiple (5) events. The code you want to focus on is located in module ModApp:
a. Sub Timer0ProjectSpecificExpirationHandler() which:
(1) Calls DisplayCurrentTime() to update the Time of Day Display.
(2) Calls PollTimersAndColorTimerStatusCells() to update the countdown timers.
(3) Calls Timer0Start to schedule the timer to run again.
b. Sub PollTimersAndColorTimerStatusCells() which updates the display on the SpreadSheet.

In the file all timers are started manually by User Click. All Timers stop when the Time of Day display is disabled.
To start all the timers programmatically, you would:

Please Login or Register  to view this content.

I hope this helps.

Lewis

[kennethbass]

Lewis,

Thank you for the response and reference! However, I need mine to be as automated as possible. I want to have a RunAll() macro assigned to the Start button next to the timer. When it starts that 8 hour countdown, I need cell C3 to start counting down from 45 minutes, when that reaches 0, then cell C4 start counting down from 2 hours and 40 minutes until it reaches 0 and so on.

So if I didn't explain well enough in the OP.

[LJMetzger]

It seems like you need additional help implementing the timers. If you upload a sample workbook, I can add code to do what you want. Please indicate what you want done (if anything), when each timer reaches ZERO.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Lewis