+ Reply to Thread
Results 1 to 8 of 8

countup timer

  1. #1
    Registered User
    Join Date
    07-14-2019
    Location
    england
    MS-Off Ver
    2016
    Posts
    5

    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 Moderator
    Join Date
    05-14-2009
    Location
    RDC
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    7,210

    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
    2007 Enterprise
    Posts
    4,557

    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
    Registered User
    Join Date
    07-14-2019
    Location
    england
    MS-Off Ver
    2016
    Posts
    5

    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
    2007 Enterprise
    Posts
    4,557

    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
    Registered User
    Join Date
    07-14-2019
    Location
    england
    MS-Off Ver
    2016
    Posts
    5

    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
    Registered User
    Join Date
    07-14-2019
    Location
    england
    MS-Off Ver
    2016
    Posts
    5

    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 e97h; Yesterday at 11:18 AM.

  8. #8
    Registered User
    Join Date
    07-14-2019
    Location
    england
    MS-Off Ver
    2016
    Posts
    5

    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)

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