Menu
All articles with 'ucase()' Tag
{ 6 Comments }
Make VBA String Comparisons Case In-sensitive [Quick Tip]
Published on Dec 1, 2011 in VBA Macros
Today, while answering a reader’s email, I wrote this VBA code, If Target.Value = “yes” Then ‘do something End If But I realized that my code would run only the Target cell has “yes” in it. It wont run if the target cell has “YES”, or “Yes” or “YeS”. This is because by default, all […]
Continue »
