mutually link checkboxes

Okay I think this is what you want.
Every check box is linked to the link check boxes procedure in module 2. I didn't want to have to link them all manually so I found some code online, it's in module 4, that will set the on action for every check box to that macro. So if you add a bunch of check boxes then you can just run that macro against the sheet with the newly added check boxes.

Good Luck.

To do this with Forms Checkboxes, pick a cell. Name it CheckBoxCell and then format each of the checkboxes with the Cell Link: CheckBoxCell

Originally Posted by mikerickson

To do this with Forms Checkboxes, pick a cell. Name it CheckBoxCell and then format each of the checkboxes with the Cell Link: CheckBoxCell

I'm not sure what that means Mike. If you look in the workbook on the overall sheet there's a player with a check box. I think he wanted if you check a player's check box then it checks the check box next to that same player on another sheet and vice versa. Will your solution do that?

I found an issue with Adrian Peterson, when you toggle the check box on and off it works fine with controlling his other check box on the RB sheet. But the check box on the RB sheet won't control the Overall sheet. I chose design view and noticed that the border of your check box on the RB sheet was a little too tall. It was up into row 3, when I adjusted it there was no longer an issue.

I should have looked at the attachment. This looks like a good advertisement for Marlet check boxes.

In the attached, I removed all the checkboxes (and all the formatting that hid the cell contents).
On any sheet in the workbook, double click a cell in column A to select that player. The cell(s) on the other sheets for that player will be similarly affected. One can add new players without modifying the code, the only requirement is that the player's name be in column C of each of the sheets and that they be unique.

This is all driven by this code in the ThisWorkbook code module.

Please Login or Register  to view this content.

My pleasure, thanks for the rep. points. :P

Please click the Thread Tools drop down box above your first post and choose solved.