+ Reply to Thread
Results 1 to 4 of 4

VBA Count down timer improvements

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    6

    Red face VBA Count down timer improvements

    Good evening

    Found a count down timer on this site and it works, but have been trying to make improvements to but so far im not successful. (After 2 weeks )

    1. Im trying to get all the cells to start count at =NOW at the same time and not have to select each one. (Tried to record a macro to select all the field to start at same time however the USERFORM 1 does not allow this.)

    2. Trying to add a stop function(Button) that does not clear the time, just displays the time at the moment it was stopped.

    Help would be appreciated as my VBA knowledge is near non existant, i have attached the file.

    Count Down Test.xls
    Last edited by Leith Ross; 09-14-2014 at 08:19 PM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: VBA Count down timer improvements

    I have added a second stop function for you.

    Also set the count up as default
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-13-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: VBA Count down timer improvements

    The default helps thank you, however it seems the second stop function does not work. Could this be due to different versions of excel?

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: VBA Count down timer improvements

    It should work. I have simply copied code from your worksheet. It works for Office 2013.

  5. #5
    Registered User
    Join Date
    06-13-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: VBA Count down timer improvements

    It works thank you , how do i change it to stop only one selected line at a time.
    I have tried to copy the start code and edit it but I cannot change it to work for stopping a single line at a time. Frustrating if you havent studied this.

+ 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. COunt down timer help please.....
    By lbjohnston in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2012, 10:20 AM
  2. count down timer
    By moley165 in forum Excel General
    Replies: 1
    Last Post: 05-22-2012, 01:19 PM
  3. Count down time and count up timer does not starts in another sheet(s)
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2010, 06:08 PM
  4. Count down time and count up timer does not starts in another sheet(s)
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2010, 07:52 AM
  5. count down timer
    By RAF JANSSENS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-05-2006, 06:51 AM

Tags for this Thread

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