I am creating a checklist for my team, which includes tasks which are to be performed daily, weekly, bi-weekly or monthly based on the task.
Initially I created a checklist in which I inserted the check boxes and linked each of them to different cells. But I found that job to be tiring as every month tasks change as per the day.
Kindly let me know how this can be achieved using VBA. Attached is a screenshot of what I created manually.
Would appreciate if a link is provided where an example is there to achieve the above.
I hope you understand what I m trying to explain. Please let me know if any input is required.
Thanks in advance.