Compare the strings

I want to check if the string contains a particular word, say, string "World" doesn't
have "ed". What the operator shall I use here? Thanks.

David

Thank you. I could not find the SEARCH function in VBA help.
Could you tell me the syntex? Thanks.

David

In VBA you can use the InStr function, like

If InStr(1, TheString, "World") > 0 Then
MsgBox "The string exists in there"
End If

--
Regards,

Juan Pablo González
Excel MVP
"yangyh" <[email protected]> wrote in
message news:[email protected]...
>
> Thank you. I could not find the SEARCH function in VBA help.
> Could you tell me the syntex? Thanks.
>
> David
>
>
> --
> yangyh
> ------------------------------------------------------------------------
> yangyh's Profile:
> http://www.excelforum.com/member.php...o&userid=26883
> View this thread: http://www.excelforum.com/showthread...hreadid=465743
>