I found code similar to this in one of NateO's posts, but its not working for me. Am I doing something wrong? I'm trying to get a cell value to change when a check box (not on userform) is checked. I named the check box "Check_box", but nothing happens. Heres the code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Check_box.Value = xlOn Then
Range("AT1").Value = "testtrue"
End If
Thanks
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Check_box.Value = xlOn Then
Range("AT1").Value = "testtrue"
End If
Thanks
End Sub