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

Prevent Case Sensitivity in VBA Code

User Rating: Not yet rated
Source Website: sourcedaddy.com
Viewed: 173 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
    Convert Formula References from Relative to Absolute
    Excel VBA Date and Time
    Force Text to Upper- or Proper Case
    VBA Debugging Tips
    Hide and Restore Toolbars in Excel
    VBA Functions
    Enter Data into Multiple Worksheets Enter Data into Multiple Worksheets
    Controlling Your VBA Code
    Prevent Users from Performing Certain Actions