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 vote139 views2 answers
Excel vba copy paste after last row
VBA
0 vote148 views1 answer
Compare dates vb
VBA
0 vote159 views1 answer
Vba copy file
VBA
0 vote149 views1 answer
Excel vba remove formatting from cell
VBA
0 vote152 views1 answer
Refresh token em vb net
VBA
0 vote144 views1 answer
Excel vba current folder
VBA
0 vote193 views1 answer
Visual basic cmd
VBA
0 vote146 views1 answer
Vb check if row has column
VBA
0 vote161 views1 answer
Vba clear collection
VBA
0 vote156 views1 answer
Programmatically copy data from one workshet to another excel
VBA