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: 150 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
    Retrieve a Workbook Name and Path
    Excel Three-Criteria Limit for Conditional Formatting
    VBA Functions
    VBA: Yes or No Message Box
    VBA Tips
    Convert Formula References from Relative to Absolute
    How to Create a Simple Macro in Excel
    Force Text to Upper- or Proper Case
    Excel VBA Date and Time
    Creating Custom VBA Dialog Boxes