Using strComp

[Middlemarch]

These return False.

isSame = StrComp("TeSt", "TeSt", vbTextCompare)
isSame = StrComp("TeSt", "TeSt", vbBinaryCompare)

I believe TextCompare is case-insensitive and Binary case sensitive.
Why don't they return True as they are the same ?

[CJ_London]

The strcomp does not return a Boolean it returns an integer value-1,0 or 1.

if they are equal it returns 0. the 1or-1 is returned if one value is greater or less than the other

See this link
https://support.microsoft.com/en-us/...9-f7442bc10b96

[Middlemarch]

Thanks very much, I had that totally wrong!