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 vote232 views1 answer
Remove frist letter from string vbnet
VBA
0 vote240 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote261 views1 answer
Vba listbox remove all items
VBA
0 vote242 views1 answer
Vba copy file
VBA
0 vote247 views1 answer
Dlete rows with blanks and space " " vba
VBA
7 votes240 views1 answer
Excerl vba array to range
VBA
0 vote248 views1 answer
How to use if condition in time vba
VBA
0 vote251 views4 answers
How to continue formula in below line in vba code
VBA
0 vote248 views1 answer
Excel filter by date not working vba
VBA
0 vote256 views1 answer
Vba run command
VBA