All articles with 'ucase()' Tag

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 »