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 vote172 views1 answer
Vba userform textbox wrap text
VBA
0 vote140 views1 answer
Convert number to minutes in vba
VBA
0 vote142 views1 answer
Vba min
VBA
0 vote137 views1 answer
Vba format currency
VBA
0 vote144 views1 answer
How to add line graph vb net
VBA
0 vote150 views1 answer
Tester si une case est vide vba
VBA
0 vote126 views1 answer
How to use VBA to add new record in MS Access?
VBA
1 vote141 views1 answer
Vba login website
VBA
0 vote135 views1 answer
Send text to clipboard vb.net
VBA
4 votes125 views1 answer
Excel vba determine number of elements in an array
VBA