Hello everybody
I have the following UDF function that returns TRUE if one substring exists within another string
Code
Function Contains(strBaseString As String, strSearchTerm As String) As Boolean
'Purpose: Returns TRUE if one string exists within another
On Error GoTo ErrorMessage
Contains = InStr(strBaseString, strSearchTerm)
Exit Function
ErrorMessage:
End
End Function
For example: The substring "Hello" exists in the string "Yes Hello everyone in this great forum"
So I can use this formula in B1
and the result should be True according to the UDF function
Now I need to check more than substring .. say I need to check "hello" or "great" or "forum" .. If any substring found , the result should be True
Hope it is clear
My imaginaton about it