Run VBA code under certain conditions

[sofas]

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

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

 

[Joe4]

Try changing this line:

    If Target.Offset(0, 2).Value = "" Then

to this:

    If (Target.Offset(0, 2).Value = "") And ((Target.Value="ttc") Or (Target.Value = "ttc10")) Then

Note however that "Target.Offset(0, 2)" is actually checing column C, not column B.
You mentioned checking column B in your explanation to see if it is blank, but your code is actually looking at column C.
So I am not sure which of these two columns you really want to check.

Since the Target is in column A, column B would look like: "Target.Offset(0, 1)".

 

[sofas]

Try changing this line:

    If Target.Offset(0, 2).Value = "" Then

to this:

    If (Target.Offset(0, 2).Value = "") And ((Target.Value="ttc") Or (Target.Value = "ttc10")) Then

Note however that "Target.Offset(0, 2)" is actually checing column C, not column B.
You mentioned checking column B in your explanation to see if it is blank, but your code is actually looking at column C.
So I am not sure which of these two columns you really want to check.

Since the Target is in column A, column B would look like: "Target.Offset(0, 1)".

Thank you very much my friend, this is what is needed

 

[Joe4]

You are welcome.
Glad I was able to help!