+ Reply to Thread
Results 1 to 4 of 4

Timer in excel stops when running simultaneously

  1. #1
    Forum Contributor
    Join Date
    06-24-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    198

    Timer in excel stops when running simultaneously

    hello

    hope somebody can help me with the attached file. it containes 3 timers and it should run independently of each other, meaning timer 1 should not stop even if i am working on timer 2 or timer 3.

    right now, when timer 1 is paused and i start another timer then try to resume the 1st timer (while the 2nd timer is still running) a run time error will occur. I hope i explain myself clearly.. the bottomline is 1 timer should not affect the other timer whether it is running or in pause.

    thanks in advance for those who can help.
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,251

    Re: Timer in excel stops when running simultaneously

    You have tripled procedures and changed names/variables (still not perfect, because in

    Please Login or Register  to view this content.
    you still have
    Please Login or Register  to view this content.
    while it is located in Row 9

    but the main point is that you use only one variable:
    Please Login or Register  to view this content.
    for all 3 timers.
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    06-24-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    198

    Re: Timer in excel stops when running simultaneously

    hmm can yu help me dit the file? im not really good atmacro.. the code was just given to me through this site also and then i tried to duplicate the codes...

  4. #4
    Forum Contributor
    Join Date
    06-24-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    198

    Re: Timer in excel stops when running simultaneously

    think i get it... . thanks soo much for your input regarding use of only 1 variable.

    What I did is I replicated the variables.. i do not know if my approach was the correct one but it seems working (fingers crossed)

    Please Login or Register  to view this content.

+ 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. [SOLVED] 2010 Excel stops working when running macros
    By Yamaha Rider in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2013, 02:40 PM
  2. running timer in excel
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2013, 10:12 AM
  3. two modules in excel not running simultaneously
    By avichandana20000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2013, 08:39 AM
  4. why excel stops running??
    By usiddiqi in forum Excel General
    Replies: 2
    Last Post: 05-17-2006, 05:14 AM
  5. [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