+ Reply to Thread
Results 1 to 7 of 7

pause button in excel

Hybrid View

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

    pause button in excel

    hello

    me again needing your epertise..

    it is an ordinary time log for me to measure how long i am performing a certain task. but since i have to perform multiple tasks, i have to "pause" the timer for 1 task before i can proceed with another.

    can anybody help me in adding a code for the pause/resume button? and when i clicked on the stop button the time elapsed will not include how long the time is paused? right now the time elapsed is just start - stop.

    i tried searching in google but i had some problem in incorporating it in my file. i need to have it in the exact format right now as i am transferring all the info in another database.

    really appreciate your help on this.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: pause button in excel

    Take a look at the modified file. I ve made the pause button work for the first timer (SPAIN). There is a start. Let me know what you think.
    Attached Files Attached Files
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

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

    Re: pause button in excel

    do you think its possible that the pause between times would be placed in U5 and U6... then when he pause again it would be placed V5 and V6 and so on... then the computation for time elapsed would compute all the columns?

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

    Re: pause button in excel

    hello

    thanks for your time. i checked the file. correct me if i am wrong but it seems the elasped time computation, ould only allow the user to pause the task once? would it be possible that user can start the timer... pause it.... restart again.. pause... resume.. pause.. resume? i mean if the user can pause and resume the task multiple times, then it would be great.

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

    Re: pause button in excel

    any help please?

  6. #6
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: pause button in excel

    it can now manage multiple pause times... HTH
    Attached Files Attached Files

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

    Re: pause button in excel

    perfect!!! super super thanks!!

+ 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. running timer in excel with start, pause and end button
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 09-23-2021, 04:36 AM
  2. Play Stop and Pause Button
    By Stanley91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2014, 12:03 PM
  3. Pause and resume button using VBA
    By kyod in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-08-2009, 08:36 AM
  4. Abort button for a macro(not the break key) and pause/resume button
    By c.vaibhav in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-21-2009, 04:22 AM
  5. Excel 2007 : Macro pause button
    By Terri_Galloway in forum Excel General
    Replies: 2
    Last Post: 02-11-2009, 12:45 PM

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