How to use a macro / VBA to uncheck a checkbox on a certain day of the month.

[Chypp]

I have a spreadsheet where I use a Checkbox that I click when a monthly payment is made, which triggers other formulas. I was wondering if there is a way I could get a macro to automatically uncheck the box on a certain day of the month (on the 20th of every month, for example) so that I don't have to remember every month to manually uncheck it.
Thanks!

[shknbk2]

You can put this code in the ThisWorkbook code section of the file. Change the 'checkboxCaption' constant to be the text showing in the checkbox, and change the 'dateToClear' constant if you want a day other than the 20th.

Please Login or Register  to view this content.