Stopwatch VBA access coding having start, stop & reset buttons

Asked By Anna Weiss 10 points N/A Posted on - 05/08/2013

Hello Techyv Friends,

I would like to create a customized Stop Watch using VBA. Will anyone be able to provide stopwatch VBA access coding, which will a form having start, stop & reset buttons. Please do the needful for helping me by providing the same.

Thanks & Regards,

Anna Weiss

• Status: Open
• Question Views: 5115
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Graham Mcnatt 5 points N/A #138480

Stopwatch VBA access coding having start, stop & reset buttons

 

Hi! I attached here the sample code in making stopwatch in VBA using excel follow this instruction on how will you apply this in you excel:

1. Copy all the code in the attachment given below

2. Launch your excel and press ALT + F11 then you will be entered in VBE

3. Press the Ctrl + R and it will display the Project Explorer

4. Double click in the worksheet in where you want to add the code

5. Paste the code that you copied into the right pane

6. Press ALT + Q  to quit in VBE

7. Save your work

This is how to test your work:

1. Enter a value you want in column A

2. Double click the value and it will start playing

3. Double click again  the value while running and it will reset the specifies the interval

4. In the black cell, just double click to stop the Stopwatch

 

About Graham Mcnatt

Questions
1

Answers
227

Best Answers
55

• Vote Up 0 Vote Down

• Posted on - 05/20/2013
• Question Category: Visual basic