+ Reply to Thread
Results 1 to 4 of 4

Timing issue with multiple countdown timers (loop related)

  1. #1
    Registered User
    Join Date
    07-28-2016
    Location
    Hervey Bay, Australia
    MS-Off Ver
    2010
    Posts
    3

    Timing issue with multiple countdown timers (loop related)

    Hi guys,

    I'm having some trouble with a set of 4 countdown timers that I have created. I want them to run concurrently, counting down by the second. Each time will be set to 5 minutes and will start on a Command Button click. When they reach 20 seconds the background of the cell will turn red. Once they reach 0 seconds they have been programmed to incremement the value of a cell, reset, and continue counting down.

    This works great for one timer, mainly great for two timers, but more than that and they seem to "trip over each other" as if the one second loops can't be processed quickly enough?

    I'd really love to find a solution to this as it's the finishing touches to a program I've been working on for a week!

    Thanks in advance

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    07-28-2016
    Location
    Hervey Bay, Australia
    MS-Off Ver
    2010
    Posts
    3

    Re: Timing issue with multiple countdown timers (loop related)

    Further testing has shown that the issue only manifests when I set another cell to display the contents of the respective countdown cells. Unfortunately I need to do this as when the countdown reaches 0 I want the cell with the replicated timer in it to display some text - but I also want the timer to continue counting. I cannot figure out a way to do this without duplicating the countdown cell contents in a second cell.

    Hope this makes sense :/

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Timing issue with multiple countdown timers (loop related)

    This uses one Ontime event for all four timers.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Registered User
    Join Date
    07-28-2016
    Location
    Hervey Bay, Australia
    MS-Off Ver
    2010
    Posts
    3

    Re: Timing issue with multiple countdown timers (loop related)

    Thanks Alpha! That code looks so niiiice :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Best way to make multiple countdown timers
    By Dave_ross in forum Excel General
    Replies: 19
    Last Post: 02-04-2019, 05:06 PM
  2. [SOLVED] Multiple countdown timers and pop-up messages/alarms on a single sheet
    By charliethechamp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2015, 06:21 AM
  3. Userform Multiple Countdown Timers
    By aalansari in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2015, 08:17 AM
  4. Countdown timers.
    By saintdave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2014, 04:47 PM
  5. Multiple Countdown timers.
    By dawidski in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2013, 11:42 PM
  6. multiple countdown timers in excel?
    By hollandrob81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2013, 04:12 PM
  7. Countdown Timers?
    By phil2006 in forum Excel General
    Replies: 2
    Last Post: 09-11-2007, 07:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1