I have a sheet that imports a column of names, and with the column of names, I have code to place a checkbox (form control) in the next 4 columns. This is what I want it to do:
The first 3 columns of checkboxes place the name into 1 of 3 categories, and the 4th checkbox is toggled to "activate" (or in this case copy the name into another sheet) the name. In a sheet with 50 names (rows of data), that's 200 checkboxes...sucks I know..

How do I get the name (data) to recognize when the corresponding checkbox has been checked? Can I name each checkbox??

This is my code for adding the checkboxes (this is only for the first column of checkboxes)
Please Login or Register  to view this content.
Is there a way to check the value (checked or not checked) of each checkbox for each column? I feel like excel doesn't know where the checkboxes, so I can't look for them.

Thanks in advance.