Disable checkbox on cell value

skorpionkz said:

Check below thread. This should give you a clue how to disable the checkbox. Always check if there was already solution to your treadhttp://www.mrexcel.com/forum/excel-questions/420586-disable-checkbox-visual-basic-applications.html

Click to expand...

AllanSull said:

Code:

Sub Disable()
If Cells(55, 7) = "No" Then CheckboxAirSus.Enabled = False
End Sub

Tried the above and get a object required error?

Click to expand...

Jon von der Heyden said:

For example, the sheet change event:

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim ctlCheckBox     As CheckBox
    
    With Me
        Set ctlCheckBox = .CheckBoxes(1) '-- assume it is the 1st checkbox, you can also refer to it by its name
        ctlCheckBox.Enabled = Not .Range("A1").Value = "No"
    End With
End Sub

Click to expand...

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim ctlCheckBox     As CheckBox
    
    With Me
        Set ctlCheckBox = .CheckBoxes(CheckboxAirSus)
        ctlCheckBox.Enabled = Not .Range("G55").Value = "No"
    End With
End Sub