condition based on value of part of a cell

[cpra3617]

How would I modify this snippet

...
If UCase(.Range("A1").Value) = "labo" Then
...

so that the condition would be true even if only part of the cell contained the string "labo"? So, for example, I would like the condition to return true if the cell contained the words "TWO PLACE HOLDERLABO" . The "labo" may exist in different positions within the cell so variations on:

If UCase(Left(.Range("A1"), 4)) = "labo"

would not work, so far as I am aware.

 

[mikerickson]

I think your example got the UCase backwards. It sounds like

If UCASE(.Range("A1").Value) = "LABO" then

is what you wanted.

About the partial situation:

If InStr(UCase(.Range("A1").Value)),"LABO") = 0 Then
    MsgBox "LABO is not in a1"
Else
    MsgBox "labo is somewhere in A1"
End IF

 

[cpra3617]

thanks