Hello,
I am trying to have "CheckBox" value become True when the Cell A1 value is greater or equalt to 100.
This is the code I have tried to no sucess:
Private Sub CheckBox_Change()
If Range("E10").Value >= 100 Then
Me.CheckBox.Value = True
Else
Me.CheckBox.Value = False
End If
End Sub
I would appriciate any advice on the subject, thanks!