+ Reply to Thread
Results 1 to 6 of 6

Timer in excel

  1. #1
    Forum Contributor
    Join Date
    01-13-2016
    Location
    Sheffield, England
    MS-Off Ver
    2016
    Posts
    199

    Timer in excel

    Hi All,

    I want to create a visual timer that counts up.
    It will have a start and stop button. So the timer will show in sheet 1 and then populate the elapsed time in sheet 2 but not overwrite the previous entries unless chosen to.
    I want the timer to be formatted in green until a certain time lapsed occurs and then turns red.
    I have managed to make a timer in excel but can't get it to populate the elapsed time to sheet 2 or to turn red after a designate time.
    Any help would be appreciated.

  2. #2
    Forum Contributor
    Join Date
    08-08-2005
    Location
    Kansas, USA
    MS-Off Ver
    2016
    Posts
    293

    Re: Timer in excel

    A google search on "excel timer" will get you several examples. If you can upload your code, someone can likely comment on it.

  3. #3
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    2,187

    Re: Timer in excel

    See if the attached does what you want.
    It places the data on Sheet1 and Sheet2 (just eliminate the code referencing Sheet 1 on the 'STOP' button if you do not require it).
    To set the 'countdown'> uncheck 'Set Countdown' checkbox > Hit 'Zero CountPeriod' button > fill countdown period textboxes > recheck 'Set CountDown' checkbox.
    Hit 'START' button > Stopwatch starts and when countdown reaches zero both StopWatch & Countdown turn red.
    Runs as a stop watch if 'Set CountDown' is left unchecked.
    If you want the present process to overwrite the previous tick the overwrite checkbox before hitting 'START'
    Date & Clock are system driven.........'START' & 'STOP' buttons flip/flop........the checkboxes and 'ZERO' button are only active when the 'STOP' button shows.
    regards.
    torachan
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    01-13-2016
    Location
    Sheffield, England
    MS-Off Ver
    2016
    Posts
    199

    Re: Timer in excel

    Hi,

    Thanks for that Torachan.
    This works a treat for my requirements.
    Is there any possibility that the timer can be preset for a count period and remain at that time period without having to input it everytime the clock has been stopped.
    Last edited by AliGW; 01-18-2019 at 08:06 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,641

    Re: Timer in excel

    Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

    For normal conversational replies, try using the QUICK REPLY box below.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  6. #6
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    2,187

    Re: Timer in excel

    delete or iterate out "'" the code at the end of cmdSTOP button

    Please Login or Register  to view this content.
    or download updated file

    regards
    torachan.
    Attached Files Attached Files

+ 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. Excel VBA Timer
    By N323100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2017, 10:50 AM
  2. timer for 30 minutes and timer based events
    By mohak12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2014, 06:20 PM
  3. TIMER in Excel
    By vinayjan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2013, 09:46 PM
  4. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  5. Timer in Excel
    By James_SF in forum Excel General
    Replies: 1
    Last Post: 12-29-2006, 11:02 AM
  6. Replies: 1
    Last Post: 03-10-2006, 08:10 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