Hi,

I am trying to figure out how to check/uncheck a form control checkbox through code based upon the true/false result of another checkbox, but cant seem to get it. I am not sure if it is possible. The following codes are the two (of many) tries. Can anyone tell me what I am doing wrong?

Sub M018_CheckBox2_Click()
    Dim ws As Worksheet
    Set ws = Worksheets("Bank Stmt")
    
    If ws.Range("BI9") = True Then 'BI9 is the cell that contains the True/False result of Checkbox1 (initiated by the user)
           ws.Range("BI10") = False   'BI10 is the cell that contains the True/False result of Checkbox2 that I want to be altered by the code with the only user intervention to be what he/she did with Checkbox1
    Else: ws.Range("BI10") = True
End If
    
End Sub
and..........

Sub M017_CheckBox2_Click()
    Dim ws As Worksheet
    Set ws = Worksheets("Bank Stmt")
    
    If ws.Range("BI9") = True Then
           ws.Range("BI10") = False
    ElseIf ws.Range("BI9") = False Then
           ws.Range("BI10") = True
    End If
    
End Sub
I have tried many others, for example ws.Range ("BI9").Value = True........or "True" to no avail.

I would appreciate any help.

Thank you,
JasonRay