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 vote118 views1 answer
Vba DisplayGridlines
VBA
0 vote125 views1 answer
Vba extract filename from path
VBA
0 vote134 views1 answer
Vb run command
VBA
2 votes112 views2 answers
Constructor vb.net
VBA
0 vote129 views1 answer
Vba sort multiple columns
VBA
3 votes126 views1 answer
Vba make long from two shorts
VBA
0 vote109 views2 answers
Excel vba copy paste after last row
VBA
0 vote129 views1 answer
Rotate image by any angle vb.net
VBA
0 vote126 views1 answer
Excel vba combine ranges
VBA
0 vote118 views1 answer
Vba add month to date
VBA