Vba Remove Case Sensitivity

'Removes case sensitivity
Option Compare Text
'Adds case sensitivity
Option Compare Binary
'Compare
debug.print StrComp(string1, string2, vbUseCompareOption) 'with choosen option
debug.print StrComp(string1, string2, vbBinaryCompare)	  'case sensitive
debug.print StrComp(string1, string2, vbTextCompare)      'case insensitive

Source: grepper.com

Similar codes

0 vote186 views1 answer
Group controls programmatically vb
VBA
0 vote186 views1 answer
Vba range clear formatting
VBA
0 vote176 views1 answer
Vba clear collection
VBA
0 vote173 views1 answer
Vba code to select image in sheet
VBA
1 vote181 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote164 views1 answer
Vb window.minimize
VBA
5 votes177 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote170 views1 answer
Vba code to open a file with login rights
VBA
0 vote113 views10 answers
Vba excel create event log
VBA
0 vote159 views1 answer
Quit excel with save changes dialog vb.net
VBA