I have the following UDF function that returns TRUE if one substring exists within another string
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