VBA code to Reset counter in a cell to 1, everyday (newbie here)

[radian89]

Hi all,

I have little experiments here, I want to know the code to reset the counter based on changes of day. so when ever i click Add number button, will add the counter +1, become 1,2,3 and so on, but it will reset to 1 again after the next day.

how to do it?

[/IMG]

thanks a lot for the help

 

[Peter_SSs]

.. C3, need not contain formula, and user define it manually, noted

C3 should not be touched at all by the user if you use the code I suggested. C3 should only ever be changed by the code itself. I suggest that you just try what I posted for a couple of days, opening the sheet a few times per day and altering C5, not C3. When you first open the workbook each day, you should see C5 reset to 1.

 

[radian89]

C3 should not be touched at all by the user if you use the code I suggested. C3 should only ever be changed by the code itself. I suggest that you just try what I posted for a couple of days, opening the sheet a few times per day and altering C5, not C3. When you first open the workbook each day, you should see C5 reset to 1.

okay, I'll try it for couple days... can't wait to see the result ray: