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 vote336 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote316 views1 answer
Vb window.minimize
VBA
0 vote330 views1 answer
Default host vbox address
VBA
0 vote341 views1 answer
Vba round to 2 decimals
VBA
0 vote329 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote323 views1 answer
Find the name of the last excel sheet vb
VBA
32 votes522 views2 answers
Excel vba column letter
VBA
22 votes481 views1 answer
Excel vba check if directory exists
VBA
0 vote346 views2 answers
Open url from vba
VBA
1 vote328 views1 answer
Change the first item in a queue vb.net
VBA