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 vote218 views1 answer
Style percent not found vba
VBA
0 vote254 views1 answer
Vba paste values
VBA
4 votes225 views2 answers
Vba array length
VBA
0 vote246 views1 answer
Putting marquee in vb.net
VBA
3 votes223 views1 answer
Excel vba get the workbook full file name with path
VBA
-1 vote232 views2 answers
How close excel through visual basic
VBA
0 vote219 views1 answer
Vba copy paste value only
VBA
1 vote220 views1 answer
Excel vba hide zero values
VBA
1 vote225 views1 answer
Close form vba
VBA
0 vote237 views1 answer
Vba apostrophe chr
VBA