"Best" way to determine Option Compare?

[Auric__]

Is there any built-in method to determine what Option Compare method is in
effect? Right now I'm just doing this (which ignores vbDatabaseCompare, which
I never use):

If "A" = "a" Then
cmp = vbTextCompare
Else
cmp = vbBinaryCompare
End If

[Deanna Earley]

Post by Auric__
Is there any built-in method to determine what Option Compare method is in
effect? Right now I'm just doing this (which ignores vbDatabaseCompare, which
If "A" = "a" Then
cmp = vbTextCompare
Else
cmp = vbBinaryCompare
End If

Out of interest why does the code need to know?
If it requires a specific compare, use StrComp() and pass an explicit mode.

[Auric__]

Post by Deanna Earley

Post by Auric__
Is there any built-in method to determine what Option Compare method is
in effect? Right now I'm just doing this (which ignores
If "A" = "a" Then
cmp = vbTextCompare
Else
cmp = vbBinaryCompare
End If

Out of interest why does the code need to know?

Replicating (and extending) various string functions: currently InStr and
Split, with more in the near future. Mostly as a mental exercise.

Post by Deanna Earley
If it requires a specific compare, use StrComp() and pass an explicit mode.

...which is the exact opposite of what I want. :-)