• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding start, pause and stop buttons in an excel macro

narayanan_olam

New Member
I want to create a macro in excel which will capture the start and stop times for any activity..

Complexity - Since I will be doing many parallel activities, i Need a pause button, which will freeze the time and will restart when I am back to the previous activity

Can anyone plz help ?
 
Narayanan_olam

Firstly, welcome to the Chandoo.org Forums

Yes, this can be done

Can you attach a file with what data layout you have
Highlight where you want times
 
How does this look?
 

Attachments

  • sample format.xlsm
    27.5 KB · Views: 66
What version of Excel?
Did you enable macros when you opened the file ?
 
I have no idea as I just downloaded it an it worked fine

Click on the below link
Enable content
Enable Macros

To use
Click on Start Timer
Click on Stop Timer

or

To use
Click on Start Timer
Click on Pause
Click on Resume
Click on Pause
Click on Resume
Click on Pause
Click on Resume etc
Click on Stop Timer
 

Attachments

  • sample format2.xlsm
    28.1 KB · Views: 109
I have no idea as I just downloaded it an it worked fine

Click on the below link
Enable content
Enable Macros

To use
Click on Start Timer
Click on Stop Timer

or

To use
Click on Start Timer
Click on Pause
Click on Resume
Click on Pause
Click on Resume
Click on Pause
Click on Resume etc
Click on Stop Timer

Hui, some problem with my computer i think... checked on my colleague's comp and its working fine..this suits my requirememt..

Thanks so much..
 
I have no idea as I just downloaded it an it worked fine

Click on the below link
Enable content
Enable Macros

To use
Click on Start Timer
Click on Stop Timer

or

To use
Click on Start Timer
Click on Pause
Click on Resume
Click on Pause
Click on Resume
Click on Pause
Click on Resume etc
Click on Stop Timer


Hui, need a small modification in the macro..

the time gets automaticaly recorded in the next line

i want to choose the row for which the time has to be recorded.. not on a sequential basis..
 
It only triggers when you are inside the Table area

hui, Getting a macro error like this -

Compile error

Cant find project or library ?

Have checked the code and tried clearing the temp files also.. The macro is not working..

The same macro is working on some systems fine but some system I am getting this error..

screen shot attached.,

plz help..
 

Attachments

  • macro error.jpg
    macro error.jpg
    136.2 KB · Views: 17
Goto VBA, Tools, References
Untick any items that say [Missing] *******

If that doesn't help what version of Excel are you using?
 
Hi Hui,


The Problem is that I'll have to work with more than one ID at a time and need to record pause/time and end time separately i.e., sometimes ID.3 might end before ID.2 and ID.1. Is there any way in which I can record the time separately for them.

I am new to macros and VBA (practically using it for the first time) so kindly help when you are free. Would be a great help.

Thank you in Advance :)

Regards,
Karan
 
Back
Top