+ Reply to Thread
Results 1 to 4 of 4

Multiple Countdown timers.

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    ILLINOIS
    MS-Off Ver
    Excel 2010
    Posts
    21

    Multiple Countdown timers.

    I have a small project in which I would like to create multiple countdown timers in excel however I'm fairly new to excel macros. Would love some assistance.

    Basically what I'm trying to get is cells a1:a100 are usernames and b1:b100 are countdown timers. All timers would start at the same number... ex 10 mins. Could anyone help me create a macro in which I could chose a1 and that starts the countdown in b1, a2 starts b2, and so on. This would be going on at different times.This part I want to stay manual. Ie b1 starts at 8:45,b2 starts at 8:46. I would like to choose the start time of the countdown.
    Point me in the right direction, send me a tutorial link, do it for me and let me learn on my own, teach me. Anything will help.

    Thanks for your help in advance.
    -Dawid

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Multiple Countdown timers.

    You should use the Application.OnTime method for this.

  3. #3
    Registered User
    Join Date
    11-12-2013
    Location
    ILLINOIS
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Multiple Countdown timers.

    Maybe have some kind of start button that starts the countdown in each cell.. Ive seen it before.. not sure where or how.. but would love a tutorial is someone has one.

  4. #4
    Registered User
    Join Date
    11-12-2013
    Location
    ILLINOIS
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Multiple Countdown timers.

    I looked into the: Application.OnTime Now, "my_Procedure"
    However im fairy new to macros.. so I am not sure how to set up a countdown timer

+ 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. How to Create Mutiple Countdown Timers In Excel
    By Janto724 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2013, 06:36 PM
  3. Multiple Timers within EXcel
    By Janto724 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-26-2013, 09:07 AM
  4. multiple countdown timers in excel?
    By hollandrob81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2013, 04:12 PM
  5. 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