Alternative to Find Function in VBA

[Lochnagar]

Hi,

I was hoping that someone might be able to point me in the right direction with regards to a vba problem that I have. Basically, is it possible to search for a particular text substring within a string e.g.

Searching for substring "is my" within
String = "this is my string"

I appreciate I could do this in excel with the 'Find' function, but I hoping that I might be able to do it in vba. Or put simply what is the vba equivalent of excels Find function?

Any help or advice, as always, will be hugely appreciated.

Thanks in advance,
Lochnagar

 

[doofusboy]

If Instr(Range("A1").Value,"my string") > 0 Then
' value being searched for is contained in string being searched
Else
' value being searched for is NOT contained in string being searched
End If

 

[VoG]

Try InStr

Sub test()
Dim myString As String
myString = "this is my string"
MsgBox IIf(InStr(myString, "is my") > 0, "Found", "Not found"), vbInformation
End Sub

 

[Lochnagar]

Brilliant thanks VoG and doofusboy (thou, I'm the one feeling like a doofus) that's just what I was needing.

Thanks again, you help is very much appreciated.

Lochnagar.