- May 6, 2020
- Office Version
I have a spreadsheet that has a checkbox on it. Because this spreadsheet will be edited many times, the checkbox will ultimately have multiple copies. Each checkbox will be calling the same macro. I want it this way because I don't want to create a new macro whenever I edit the spreadsheet. The ultimate plan is to have all checkboxes change to state of the checkbox that was just checked. So, is there a way to detect the state of the checkbox that triggered the macro?