Codepended Check Boxes

[igormigor]

Hi all,

I have 2 check boxes in sheet. Each of them controls separate cell. If I check Box1, cell B12 will show "True". If I check Box2, cell B14 will show "True".
I need when I check one of the boxes, the other one automatically to be unchecked. In same time only one box can be checked.

Below is my code. There is conflict in it and does not work properly.

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
        Range("B12").Value = True
        CheckBox2.Value = False
        End If
If CheckBox1.Value = False Then
        Range("B12").Value = False
        CheckBox2.Value = True
        End If
End Sub

Private Sub CheckBox2_Click()
If CheckBox2.Value = True Then
        Range("B14").Value = True
        CheckBox1.Value = False
        End If
If CheckBox1.Value = False Then
        Range("B14").Value = False
        CheckBox1.Value = True
        End If
End Sub

Any ideas how to fix this?

Thank you

Igor