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?

[Matthew Gates]

You are using the InStr function backwards.

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

[Matthew Gates]

You can also use the Like operator to find "yes."

mystring = "thewordyesisengravedinhere"
If mystring Like "*yes*" Then
MsgBox "Yes was found"
Else
MsgBox "Yes was not found"
End If