Solved: = <> vba case sensitive

[chungtinhlak]

is it true that in vba, operators are cased sensitive?

I use the following code and it's cased sensitive. In the cell, ray is all cap. is try ray and Ray and it does not work, when i RAY it work.

all these time, i thought that vba is not cased sensitive?

[VBA]
If Range(focal & usedcell).Value <> "ray" Then
msgbox ("Does not belong to Ray")
Else
MsgBox ("Belong to Ray")
[/VBA]

[Bob Phillips]

It is. try

[vba]

If LCase(Range(focal & usedcell).Value) <> "ray" Then
msgbox ("Does not belong to Ray")
Else
MsgBox ("Belong to Ray")
End If
[/vba]

[lucas]

Bob, any reason using Option Compare text is not a good solution for this?

[VBA]Option Explicit
Option Compare Text
Sub a()
If Range("A1").Value <> "ray" Then
MsgBox ("Does not belong to Ray")
Else
MsgBox ("Belong to Ray")
End If
End Sub
[/VBA]

[chungtinhlak]

so compare text option make it not case sensitive?

[Bob Phillips]

Bob, any reason using Option Compare text is not a good solution for this?

I never use it Steve, can never remember what its setting is. Anyway, I am not a fan of implicit settings (witness my rants against default values), so I prefer being explicit and descriptive in my code.

[lucas]

That answers my question Bob. Thanks and I hope to be as conscientious as you are one day......takes dedication.

Good insights.

I do use it in cases like this but only if there are no other procedures in the module that might be affected by it besides the one I am concerned with......

[Bob Phillips]

Years of experience of debugging old code mate. If you can't learn as you get older, age would be an even bummer rap.