Hi All,

I am trying to devise a way for a sheet to be signed off by entering a 4 digit number in a cell
I found this code online but I keep getting errors

I have very little knowledge of VBA so any help is greatly appreciated

[Sub Worksheet_Change(ByVal Target As Range)

Set Target = Range("A1")
If Target.Value = "1234" Then
Range("C1").Value = "Signature 1 OK"
' Else
' Range("C1").Value = "Signature?"
End If

Set Target = Range("A2")
If Target.Value = "666" Then
Range("C2").Value = "Signature 2 OK"
End If

End Sub]