String Handling

[Hap]

I have a string that looks like this:

string1 = "A1, A2, B4, C8, M5, X2, Z1"

I would like a simple boolean to let me know if:

string2 = "B4"

is found in string 1.

I am sure this is possible but I don't know how to do it.

Any help would be appreciated.

 

[KenCriss]

Is string 2 going to be another cell in the worksheet or would the user be identifying it in an InputBox?

 

[Andrew Poulsom]

Like this?

Sub Test()
    Const string1 = "A1, A2, B4, C8, M5, X2, Z1"
    Const string2 = "B4"
    MsgBox InStr(1, string1, string2) > 0
End Sub

 

[Hap]

That should work just fine.

Thank you Andrew.