How to compare strings in VBA

[sony170]

Usually i use the if string1 = string 2 then .... method.

but it only performs case-sensitve comparisons. so i looked online and found this code:

 compareResult = String.Compare(string1, string2, False, CultureInfo.InvariantCulture)

however, when i paste it in my code, i get the error saying

Expected "("

and it points to the period in between String and Compare.

what am i doing incorrectly?

[hatman]

you want to use strcomp() rather that string.compare()... I think the syntax is correct from there...

[Cbrine]

Hatman,
A quick fix for your issue with non-case sentitive values would be

If UCase(Var1)=UCase(Var2) then


You convert the test values both to Upper case and do the compare. That way you don't affect the values, but the case doesn't matter.

HTH
Cal

[hatman]

Cbrine: that's true, but strcomp also has an argument that allows you to specify whether the comparison is case sensitive or not:

vbUseCompareOption -1 Performs a comparison using the setting of the Option Compare statement.
vbBinaryCompare 0 Performs a binary comparison.
vbTextCompare 1 Performs a textual comparison.
vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on information in your database.


the value of 1 gives a test comparison without case sensitivity...

[Cbrine]

hatman,
StrComp will definitly do the job, I was just providing you with another alternative option.

[NateO]

This is all true, and here's another way:

Option Compare Text

Sub foo()
MsgBox "test" = "Test"
End Sub