Disable checkbox on cell value

[AllanSull]

Is there a way to disable a checkbox if say A1="No"?

 

[AllanSull]

I'm trying to make it grayed out if G51 is No, but not grayed out if G51 is Yes.

 

[Jon von der Heyden]

That's still not clear!

To disable it when G51 is No then all you need is:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim ctlCheckBox     As CheckBox

    With Me
        Set ctlCheckBox = .CheckBoxes("CheckboxCW100")
        ctlCheckBox.Enabled = Not .Range("G51").Value = "No"
    End With
End Sub

I really don't get what you are trying to do with:

        If .Range("G51") = "No" Then
             ctlCheckBox.Value = 2
        Else
             ctlCheckBox.Value = 0
        End If

I mean, what purpose does it serve? You are forcing the value of the checkbox to be TRUE when G51 is No, and otherwise FALSE.

 

[AllanSull]

Its puropse is just visual, so that when the checkbox is disabled, it clearly looks disabled by being grayed out rather than just unclickable.

 

[Jon von der Heyden]

That's not answering my question...

 

[AllanSull]

You asked what is the code's purpose. Its purpose is to gray out the checkbox when G51 is "No", otherwise return it to unchecked. The problem is I don't know how to stop it returning to unchecked when the user actually wants to check it.