- Stop doing what you are and go read Unleashing the Ideavirus by Seth Godin. Even if you have already read it, do it again. It helps keeping your mind alive.
- My plans to start Calvin Fund are slightly delayed, thanks to my forgetful finger, I lost my login password at the trading site and would take a while before I have it up again. Meanwhile, market seems to have done one full circle, whatever 😉
Saw this (look right) when I went to Landmark Bookstore few days ago. Now tell me, how many of you have actually played “Ashta Chamma”, “Puli-Meka” “Daadi” when you were kids? I am not sure what you might have called them, but these games exist pretty much in every state. Good to find that someone is selling them neatly packed in toys section of a leading bookstore.- If you ever happen to be Chennai during the summer time and have really nothing to do, dont even think of going to Marina beach. We did that last weekend and I still feel itchy, dirty, sweaty and angry inside for doing that.
- We are off to Vizag for a few days, to our in-laws place. I would resume regular broadcast on PHD only on 10th April.
FREE Calendar & Planner Excel Template for 2026
Here is a fabulous New Year gift to you. A free 2025 Calendar Excel Template with built-in Activity planner. This is a fully dynamic and 100% customizable Excel calendar for 2025.
6 Responses to “Make VBA String Comparisons Case In-sensitive [Quick Tip]”
Another way to test if Target.Value equal a string constant without regard to letter casing is to use the StrCmp function...
If StrComp("yes", Target.Value, vbTextCompare) = 0 Then
' Do something
End If
That's a cool way to compare. i just converted my values to strings and used the above code to compare. worked nicely
Thanks!
In case that option just needs to be used for a single comparison, you could use
If InStr(1, "yes", Target.Value, vbTextCompare) Then
'do something
End If
as well.
Nice tip, thanks! I never even thought to think there might be an easier way.
Regarding Chronology of VB in general, the Option Compare pragma appears at the very beginning of VB, way before classes and objects arrive (with VB6 - around 2000).
Today StrComp() and InStr() function offers a more local way to compare, fully object, thus more consistent with object programming (even if VB is still interpreted).
My only question here is : "what if you want to binary compare locally with re-entering functions or concurrency (with events) ?". This will lead to a real nightmare and probably a big nasty mess to debug.
By the way, congrats for you Millions/month visits 🙂
This is nice article.
I used these examples to help my understanding. Even Instr is similar to Find but it can be case sensitive and also case insensitive.
Hope the examples below help.
Public Sub CaseSensitive2()
If InStr(1, "Look in this string", "look", vbBinaryCompare) = 0 Then
MsgBox "woops, no match"
Else
MsgBox "at least one match"
End If
End Sub
Public Sub CaseSensitive()
If InStr("Look in this string", "look") = 0 Then
MsgBox "woops, no match"
Else
MsgBox "at least one match"
End If
End Sub
Public Sub NotCaseSensitive()
'doing alot of case insensitive searching and whatnot, you can put Option Compare Text
If InStr(1, "Look in this string", "look", vbTextCompare) = 0 Then
MsgBox "woops, no match"
Else
MsgBox "at least one match"
End If
End Sub