Question : excel vba compare string ignore case
Answered by : vastemonde
'Removes case sensitivity
Option Compare Text ' a < B
'Adds case sensitivity
Option Compare Binary ' A < B < a < b
'Compare
Debug.Print StrComp(string1, string2, vbUseCompareOption) 'Microsoft Access only
Debug.Print StrComp(string1, string2, vbBinaryCompare) 'case sensitive
Debug.Print StrComp(string1, string2, vbTextCompare) 'case insensitive
Source : https://www.oreilly.com/library/view/vb-vba/1565923588/1565923588_ch07-1677-fm2xml.html | Last Update : Sat, 30 Jan 21