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

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

Code:

---

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?

You are using the InStr function backwards.

Code:

---

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

---

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

Code:

---

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

---