I have a worksheet I am developing that will eventually have about 3,000 checkboxes. I found a macro posted online to create the checkboxes, which works great. I also have a macro which will run an individual checkbox to do the following to the adjacent cell if the checkbox is clicked: change the cell value, lock the cell, and format the cell. Both sets of code work great. The problem is I will have to create 3,000 macros with 3,000 different names and open 3,000 checkboxes to assign the appropriate macro. I want to assign one macro to every checkbox as it is created that assigns a universal macro which simply says, if this checkbox is clicked, then make changes to the adjacent cell. I added an .onAction command to the below insertCheckboxes code to assign a macro called CheckBoxUniversal_Click. That works, now I need to create the code for CheckBoxUniversal_Click which will tell excel to make changes to the adjacent cell. Thoughts?
Please Login or Register to view this content.
Bookmarks