Home / MS-Excel / General Formatting

Prevent Case Sensitivity in VBA Code

Keep Excel from distinguishing between capital and lowercase letters in your text.

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. There are many times, however, where you would like Excel VBA not to use binary comparisons like this (e.g., when counting entries) and you would like it to see Cat and cat as the same. You can do this easily in at least two different ways.