VBA: Loop CheckBox ActiveX If Value True, Enaled = False Same Column and Row

[morges]

Hi!

Im want to make a loop for the purpose of entering and counting votes, so that when one ActiveX CheckBox is clicked the checkboxes in the same row and column are disabled (as you have to prioritise among candidates and can online votes for each one time).

I have 14 columns and 24 rows of checkboxes. I have tried to look into whether I could assign each checkbox to a cell and then disable the cell row and column of the checked cell.

I have attached an image of the sheet and the editor, and hope that you can put me in the right direction of finding a solution. Thank you in advance!

An example of my current code (which is manual and too burdensome to run efficiently):
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
CheckBox2.Enabled = False
CheckBox3.Enabled = False
CheckBox4.Enabled = False
CheckBox5.Enabled = False
CheckBox6.Enabled = False
CheckBox7.Enabled = False
CheckBox8.Enabled = False
CheckBox9.Enabled = False
CheckBox10.Enabled = False
CheckBox11.Enabled = False
CheckBox12.Enabled = False
CheckBox13.Enabled = False
CheckBox14.Enabled = False
CheckBox15.Enabled = False
CheckBox29.Enabled = False
[...]
crosscounter = crosscounter + 1
Else
CheckBox2.Enabled = True
CheckBox3.Enabled = True
[...]


Best,
Morten

 

[morges]

Link to image: Imgur: The most awesome images on the Internet