Microsoft Excel
--
Questions
--
Followers
Top Experts
How to add multiple checkboxes using VBA in Excel 2010
Hi,
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.
Screensht.jpg
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.
Screensht.jpg
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
This is working perfectly fine. Thanks for your help.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.