Updating Checkbox - Run-time Error 91 - Object variable or With block variable not set

Hey,

I have been trying to ensure that one check box is ticked across a row. Each time I select the check box I receive the error "Run-time error 91 - Object variable or With block variable not set".. Please see code below

Option Explicit
Dim CheckBox182  As CheckBox
Dim CheckBox11  As CheckBox
Dim CheckBox12 As CheckBox

Sub CheckBox182_Click()

With Worksheets("02.01.20")
    If CheckBox182.Value = True Then
        CheckBox11.Value = False
        CheckBox12.Value = False
    End If
End With

End Sub
 Sub CheckBox11_Click()
 
  Set CheckBox11 = CheckBox11
    If CheckBox11.Value = True Then
        CheckBox182.Value = False
        CheckBox12.Value = False
    End If
End Sub
Sub CheckBox12_Click()
   
    If CheckBox12.Value = True Then
        CheckBox182.Value = False
        CheckBox11.Value = False
    End If

End Sub

Any help will be appreciated.
Nika

When I do not declare the variables I get a compile error message "Variable not defined"

Why are you setting CheckBox11 equal to itself, does the worksheet exist, are all the checkboxes on the sheet ?

I have attached the file for you to have a look. I was just trying the code with the first set of checkboxes and wanted to see if it worked. The user must check only on of the three in that row. This is a form that has been in use and I wanted to improve. If the option boxes would be better I will change as well. Just trying to improve the sheet before they start the new year.
Thanks for all the help.
Nika

I want the ticks to be row specific and when I use the option buttons I can only select for the entire group. I tried by assigning the option button to the another cell for that row but it didn't work.
Nika

Thanks for the assistance. I will use your suggestions because this was a form being used and based on numerous issues they wanted improvement. The main problem was the check boxes.

O.M.G. not another case of merged cells.!!!!!!!!!!!!

Always look at a total project and anticipate the potential for problems.
Pointless solving problems one by one only to be met by the insurmountable further down the line.