These return False.
I believe TextCompare is case-insensitive and Binary case sensitive.Code:isSame = StrComp("TeSt", "TeSt", vbTextCompare) isSame = StrComp("TeSt", "TeSt", vbBinaryCompare)
Why don't they return True as they are the same ?
These return False.
I believe TextCompare is case-insensitive and Binary case sensitive.Code:isSame = StrComp("TeSt", "TeSt", vbTextCompare) isSame = StrComp("TeSt", "TeSt", vbBinaryCompare)
Why don't they return True as they are the same ?
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
Thanks very much, I had that totally wrong!