string manipulation

banavas · Jul 9, 2004

Dear Friends,

does anyone has any piece of code that returns true is string
contains string B and false otherwise?

Thank you in advance.

Leo Heuser · Jul 9, 2004

Have a look at the INSTR() function.

JE McGimpsey · Jul 9, 2004

Take a look at the InStr method in VBA Help. You can return True/False
with:

Dim bAcontainsB As Boolean
bAcontainsB = InStr(strA, strB) > 0