Hello, I have this code to show a spinning message when I enter a value in column A and column B is empty. Can I modify the code to make it appear only when I type only the word ttc or ttc10
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 And Target.Row > 1 Then
If Target.Offset(0, 2).Value = "" Then
MsgBox "Attestation"
Target.Offset(0, 2).Select
End If
End If
End Sub