The code below is used in a search to find a row that matches a
person's name entered into a text box on a userform. I can't understand
why my like comparison isn't working:

Dim chkRequestor As String
Dim FindRequestor As String
Dim StrRequestor As String

chkRequestor = Me.txtFindRequestor.Value
StrRequestor = "*" & UCase(chkRequestor) & "*"
Requestor = Range("c" & rowindex).Value
FindRequestor = "*" & UCase(Requestor) & "*"

If StrRequestor Like FindRequestor Then
'Do commands
end if

The strrequestor value I'm using is "*SHELLEY*" and the FindRequestor
value is "*SHELLEY BOWMAN*"...why isn't this working???

Thanks,
Shelley

I forgot to add Dim Requestor as string, but it is already in my code.
Help is much appreciated!!

Shelley

Isn't your comparison backwards?

? "*SHELLEY BOWMAN*" like "*SHELLEY*"
True

works for me,

but you are doing

"*SHELLEY*" Like "*SHELLEY BOWMAN*"

testing:
? "*SHELLEY*" Like "*SHELLEY BOWMAN*"
False

If you actually want to find Shelley Bowman in Shelley, then a false result
would be correct.

--
Regards,
Tom Ogilvy


"sbowman" wrote:

I forgot to add Dim Requestor as string, but it is already in my code.
Help is much appreciated!!

Shelley

Thank You!!! Due to my overworked state, I am having "technical
difficulties" today :-)

Shelley