Hello reader, my friend & supporter,
I am happy to announce that Excel School is open and ready for registrations.
Visit Excel School page to learn more and sign-up.
In this post, you can find some information about the program and links to sign-up.
What is Excel School?
Excel School is an online Excel Training Program. It is a structured & comprehensive program to help beginners & intermediate-level users become awesome in Excel in a few weeks of time.
It contains, over 20 hours of clear, detailed video instructions, 45 downloadable workbooks and an online classroom area to help you learn any Excel topic you want at any time.
How does it work?
Once you join Excel School,
- You will be given a userid and password to access excel school classroom
- Once you login to excel school, you will find links to all the material
- You can view lessons in any order or follow the order recommended by me
- You can download example excel files, home work and videos (if you sign up for download option) for further learning
- You can ask questions or discuss topics with other classmates thru comments
- Once 2 weeks, I will send you a news-letter with information, links and discuss course progress
See the video aside to understand how Excel School works.
Learn more about Excel School from this guide [PDF].
Who should Join?
Excel School is for you if you use excel everyday and looking for ways to improve your productivity, skills and mojo. If you struggle writing or mixing formulas, compose beautiful & insightful charts or tables, understand & use various features like conditional formatting, validations, pivot tables, macros etc. then Excel School is the right program for you.
That said, the program will not help you much if you are a genius in Excel and can bake a cake with VBA. As Debra says, “if you are John Walkenbach, … Excel School is not for you“.
What topics are covered?
In Excel School, we cover these 12 topics in very detail.
| Excel School Topics: | |||
| Formulas | Formatting | Conditional Formatting | Basic Charting |
| Advanced Charting | Excel Tables | Pivot Tables | Data Validation, Filters |
| Advanced. Formulas | Importing External Data | Shortcuts, Productivity | Basic Form Controls, Macros |
Sign-up for Excel School Today:
Excel School comes in 2 flavors.
You can sign-up for ONLINE Option for $67 and access all the lessons online. You will be able to download example files, some bonus material. But you cannot download the videos.
For that, you need ONLINE+DOWNLOAD Option which costs $97. This way, You can view lessons offline or even after Excel School is closed.
[If you are from India, Click here to Pricing in INR]
Any Questions?
- Visit Excel School FAQs page to get answers.
- Visit Excel School sales page to get full details
- Checkout Testimonials from Past Students to know how it feels.
- Download a sample lesson and see it for yourself.
If you still have questions,
Write to me at chandoo.d @ gmail.com or post a comment here. I will be very glad to answer your questions.
See you in Excel School.
PS: I am done with Excel School 3 launch work now. Regular broadcast should begin tomorrow.
PPS: Go ahead and join Excel School. You know its going to be awesome. Go now.
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