• 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.

simply timer help with VBA

kyjak555

New Member
Hi

I need to make sure that all the tables are in one sheet and that they are turned on separately
 

Attachments

  • simple-timer (3).xlsm
    20.1 KB · Views: 3
In the attached, I've renamed your 4 buttons:
Button1, Button2, Button3, Button4
and renamed the corresponding 4 tables:
durations1, durations2, durations3, durations4

I've deleted your named ranges.

I've updated your startStopTimer macro. It's a bit verbose so there's a commented-out slightly shorter version.
 

Attachments

  • Chandoo47552simple-timer.xlsm
    22.2 KB · Views: 7
which rows in the code should I edit so I can add more tables?
Code:
ButtonNames = Array("Button1", "Button2", "Button3", "Button4")
TableNames = Array("durations1", "durations2", "durations3", "durations4")
Two tables have been added in the attached.
 

Attachments

  • Chandoo47552simple-timer.xlsm
    23.8 KB · Views: 8
See attached. You should be doing this then you'll know how to do it. I'm not going to be here all the time to update your project.
There's also a macro (ClearTables) to clear all the tables and reset all the buttons to Start.
 

Attachments

  • Chandoo47552simple-timer.xlsm
    37.1 KB · Views: 6
it looks amazing. send me a contact to send you a present:)
See attached. You should be doing this then you'll know how to do it. I'm not going to be here all the time to update your project.
There's also a macro (ClearTables) to clear all the tables and reset all the buttons to Start.
if you have time for macro (ClearTables) to clear all the tables and reset all the buttons to Start. I would be grateful. you have a little present from me
 
Hi i need a little update. when I turn on the start button, the test box turns green
 

Attachments

  • timer testDM.xlsm
    44.9 KB · Views: 2
Back
Top