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 vote294 views1 answer
Excel web scraping
VBA
1 vote271 views1 answer
Vba delete file
VBA
0 vote283 views1 answer
Vba test optional argument
VBA
0 vote276 views1 answer
Vba check 32 or 64 bit
VBA
0 vote276 views1 answer
Excel vba move down to next visible cell
VBA
15 votes380 views2 answers
Xl vba dynamic string array
VBA
1 vote270 views1 answer
Excel date to unix timestamp
VBA
0 vote274 views1 answer
Vba get application version
VBA
0 vote271 views1 answer
Remove frist letter from string vbnet
VBA
8 votes359 views1 answer
Vba make a short integer from two bytes
VBA