Comparing text to cells but only partial match

i have the following

Code:

---

If RangeAI.Value = cell.Value Or RangeAI.Value = "0000" Then
        NotEqual = False
End If

---

How do i chance the second bit so that it doesnt just hit on the entire string but also when it is only a partial hit? I know how to do that with find, but not with the value thing.

probably a stupid question, but i really cant find the answer.

TIA Frank

Quote:

---

Originally Posted by Regouin

Code:

---

If RangeAI.Value = cell.Value Or RangeAI.Value = "0000" Then
NotEqual = False
End If

---

How do i chance the second bit so that it doesnt just hit on the entire string but also when it is only a partial hit? I know how to do that with find, but not with the value thing.

---

Code:

---

If RangeAI.Value = cell.Value Or RangeAI.Value Like "*0000*" Then
    NotEqual = False
End If

---

thanks, i was so close

tried

Code:

---

RangeAI.Value Like "0000"

---

and tried

Code:

---

RangeAI.Value = "*0000*"

---

but didnt think of comparing them, it works beautifully thanks.

Frank