simply timer help with VBA

[kyjak555]

Hi

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

 

[p45cal]

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.

 

[kyjak555]

it looks great. how can i add more tables? I need them at least 25

 

[kyjak555]

and please clear the tables from old dates

 

[p45cal]

and please clear the tables from old dates

So you only ever want one row in a table? If not, what decides whether a date is an 'old date' or not?

 

[p45cal]

it looks great. how can i add more tables? I need them at least 25

Later today I'll add 2 more tables and buttons. I'll leave you to do the repetitive work and add any more that you need.

 

[kyjak555]

which rows in the code should I edit so I can add more tables?

 

[p45cal]

which rows in the code should I edit so I can add more tables?

ButtonNames = Array("Button1", "Button2", "Button3", "Button4")
TableNames = Array("durations1", "durations2", "durations3", "durations4")

Two tables have been added in the attached.

 

[kyjak555]

I can't do it at all. can you define 19 more tables for me there? PLS

 

[p45cal]

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.

 

[kyjak555]

it looks amazing. send me a contact to send you a present

 

[kyjak555]

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

 

[p45cal]

if you have time for macro (ClearTables) to clear all the tables and reset all the buttons to Start.

It's there already!
From the sheet, on the keyboard press Alt + F8, choose ClearTables and click Run.

 

[kyjak555]

Hi i need a little update. when I turn on the start button, the test box turns green

 

[p45cal]

Attached

 

[kyjak555]

thank you my friend you are the King in Excel many thanks

 

[p45cal]

send me a contact to send you a present

@kyjak555 sent me a gift by post which I got today, so this is a public thank you!