Cells as Buttons that will start a Countdown

[Toolmaker4]

I have seen ways to make cells as buttons to put checkmarks. What I want though is to make cells clickable. Then after it is clicked it will start a countdown.
To be more exact.

1. Click cell
2. Once cell is clicked it will have the number 10
3. Everyday it will count down to 9 until 0
4. Once it reaches 0 the cell will be blank again. (This one isn't a big deal if the 0 is still left in there)

Is this possible to do?

[xladept]

Try this in the sheet module:

Please Login or Register  to view this content.

[Toolmaker4]

Awesome it worked!
But, is there a way to make it so that the countdown is not initiated by a another click but instead by date or days.
What I was thinking was the logic is once its clicked it has a date associated with it. It can then reference the current date and lets say the difference is 3 then the number will be 7. if its 10 then its 0.
If this is too complicated then thank you for your help! I can probably work off of what you gave me.

[xladept]

Thanks for the rep!

Do you mean this?

Please Login or Register  to view this content.

[Toolmaker4]

This is like 95% of what I need so again thank you!
Is there a way to make ADat = the date of change tho (or date of click or selection)
I will mark this as solved though because if the above can't be done I can work with what I have.

[xladept]

Not sure what you mean - ADat is compared to the Current Date. You could put ADat anywhere - it doesn't need to be in the code