Cells with countdown 30 or 60 minutes

**nikoskir** · 12-15-2016, 07:33 AM

Hello,
my name is Niko and i am from Greece,
i am not sure if my asking is already been answered
but if so please point me.
What i want to achieve is :
100 cells as buttons named from 1 to 100 which will act as countdown timers for 30 or 60 minutes.
Each time i press a button it will ask either 30 or 60 minutes and when i check it it will start counting.
At the end the button will change color lets say black if the original is yellow for instance.
Inside the cell it will show the number of the button and the time when it is counting.
When the timer reaches the end except color changing when i press it it will go to original state idle with yellow color.
My other thought is to have 4 buttons 30min-60min-start-reset outside the main buttons so when i check one of the main buttons
they will interact with them.
I know this project has to be paid.
So any guide and help will be much apreciated.

Thanks in advance

**mehmetcik** · 12-15-2016, 06:31 PM

Khalispera Nico

what you ask is easy to achieve especially on a userform.

I will start something for you

Let me know what you think.

**nikoskir** · 12-19-2016, 11:23 AM

Khalispera

and thanks for your reply,
it is as i described it,
very nice work
i am not so much on making this kind of coding
and when i see something like this on excel
i am getting fascinated....
although it needs some trimming
1) time has to be in minutes (i have managed to edit a line and achieve this) MyTime = Now + TimeSerial(0, 0, 1 * 60)
2) each button has to have 2 states
a)first press ------- start counting
b)second press -------- resets to original start state even if its counting (green)or it has reached the end (yellow)

Thanks in advance

regards Niko