19,154 tutorials online
20 tutorials pending review
763 dead links removed

Prevent Case Sensitivity in VBA Code

User Rating: Not yet rated
Source Website: sourcedaddy.com
Viewed: 152 times
Reported For Abuse / Broken Link: 0 times
(Report Link)

Rate this tutorial:

By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This means that it sees Cat and cat as two different words.

Other Tutorials From This Category
    Force Text to Upper- or Proper Case
    Enter Data into Multiple Worksheets Enter Data into Multiple Worksheets
    Prevent Unnecessary Prompts
    Run Procedures on Protected Worksheets
    VBA Debugging Tips
    Excel Three-Criteria Limit for Conditional Formatting
    Hide and Restore Toolbars in Excel
    Prevent Case Sensitivity in VBA Code
    Prevent Users from Performing Certain Actions
    Excel VBA Date and Time