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 vote134 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote164 views1 answer
Vba dictionary clear
VBA
0 vote147 views1 answer
Quit excel with save changes dialog vb.net
VBA
7 votes161 views1 answer
Vba array declaration
VBA
0 vote157 views1 answer
How to carry text to the next line in a label in vb.net
VBA
-1 vote178 views1 answer
Code for reading letters only in vb 6
VBA
0 vote190 views1 answer
How to call gcd in vba
VBA
0 vote164 views1 answer
.net crash app
VBA
0 vote176 views1 answer
Iterate all file in a folder vba
VBA
8 votes234 views1 answer
Excel vba determine number of elements in a 2D array
VBA