WednesdayC
Board Regular
- Joined
- Nov 7, 2010
- Messages
- 201
- Office Version
- 2016
- Platform
- MacOS
Hi All
Can anyone help me please.
I have a Public count variable, whose value is in a cell on a Worksheet, which clicks up automatically on calling a certain macro. What I am trying to achieve is that even if the Workbook is closed down and reopened, provided the date has not clicked over to the next day, the Count variable will continue to click up, whenever the macro is called.
However whenever the date clicks over to the next day, the Count variable should reset to 0.
I am not sure how to achieve this.
Thanks in advance.
Wednesday
Can anyone help me please.
I have a Public count variable, whose value is in a cell on a Worksheet, which clicks up automatically on calling a certain macro. What I am trying to achieve is that even if the Workbook is closed down and reopened, provided the date has not clicked over to the next day, the Count variable will continue to click up, whenever the macro is called.
However whenever the date clicks over to the next day, the Count variable should reset to 0.
I am not sure how to achieve this.
Thanks in advance.
Wednesday