Very quick question - how can i check if something exists in a string? (InStr)

[qpabani]

If I did this:

mystring = "Thewordyesisengravedinhere"

How can i make an if statement that sends a messagebox if the word "yes" is in a string?

I tried

mystring = "thewordyesisengravedinhere"
If InStr("yes", mystring) Then
MsgBox "Yes was found"
Else
MsgBox "Yes was not found"
End If

but it doesnt work.. anyone know?