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: 145 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
    Enter Data into Multiple Worksheets Enter Data into Multiple Worksheets
    Change Text to Upper- or Proper Case
    Convert Formula References from Relative to Absolute
    Track and Report Changes in Excel
    VBA Tips
    VBA Debugging Tips
    How to Create a Simple Macro in Excel
    Excel Macro
    VBA: Yes or No Message Box