PDA

View Full Version : [SOLVED] Comparing text to cells but only partial match



Regouin
05-24-2005, 06:33 AM
i have the following



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

Bob Phillips
05-24-2005, 06:42 AM
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.



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

Regouin
05-24-2005, 06:44 AM
thanks, i was so close

tried



RangeAI.Value Like "0000"

and tried



RangeAI.Value = "*0000*"


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

Frank