+ Reply to Thread
Results 1 to 8 of 8

countup timer

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    countup timer

    hey

    i already have count up ter in my excel.. but its stop if i write anything in my excel..please fix the code

    thx
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: countup timer

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

    Thanks again for all your hard work here!

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: countup timer

    .
    This macro will allow you to work with the workbook while the timer is running :

    Please Login or Register  to view this content.


    As will this one :

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Re: countup timer

    Quote Originally Posted by Logit View Post
    .
    This macro will allow you to work with the workbook while the timer is running :

    Please Login or Register  to view this content.


    As will this one :

    Please Login or Register  to view this content.
    thanks for ur help, but i only need code that auto run count up timer after i open excel without stop, until i left excel timer should reset
    no need buttons

    this my old code, its working but stop after write in excel, kindly fix it

    thanks

    module code
    Please Login or Register  to view this content.



    thisworkbook code
    Please Login or Register  to view this content.

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: countup timer

    .
    You could have utilized the same Private Sub Workbook_Open command for the
    macros I provided.

    Attached is the amended project that will auto start when the workbook opens .
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Re: countup timer

    Quote Originally Posted by Logit View Post
    .
    You could have utilized the same Private Sub Workbook_Open command for the
    macros I provided.

    Attached is the amended project that will auto start when the workbook opens .
    Thank you< solved

  7. #7
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Re: countup timer

    Quote Originally Posted by Logit View Post
    .
    You could have utilized the same Private Sub Workbook_Open command for the
    macros I provided.

    Attached is the amended project that will auto start when the workbook opens .
    thank u bro, but i see when i add new rows or delete some rows the timer have mistake position
    please fix it to be always under the table
    Attachment 632396
    see photo, this the problem

    i want timer in same position even if i delete and add new rows
    under the table like u see it once u open the file
    HS CODE DONE.xlsm

    thanks
    Attached Files Attached Files
    Last edited by Undo; 07-15-2019 at 11:18 AM.

  8. #8
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Re: countup timer

    Attachment 632437
    kindly edit in this file

+ 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. Countdown timer Working BUT starting the timer repeatedly SPEEDS UP TIMER!
    By Vinospam in forum Excel Programming / VBA / Macros
    Replies: 67
    Last Post: 03-30-2019, 06:42 PM
  2. [SOLVED] Countup on change of matching cells
    By justinwb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-26-2018, 03:11 AM
  3. [SOLVED] Countup time and display in a cell
    By kersplash in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2018, 12:51 AM
  4. Creating a countup timer
    By impala096 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2016, 10:37 AM
  5. [SOLVED] Countup & Display Total Value
    By gtudor in forum Excel General
    Replies: 3
    Last Post: 01-07-2015, 07:16 AM
  6. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  7. [SOLVED] Stopping a Timer / Running a timer simultaneously on Excel
    By Paul23 in forum Excel General
    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