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 vote281 views1 answer
Openfiledialog specific folder
VBA
1 vote294 views1 answer
How to put a gridpain in a vbox
VBA
1 vote283 views1 answer
Set font for ms chart vb.net
VBA
3 votes262 views1 answer
Excel vba read registry key value
VBA
1 vote278 views1 answer
Excel vba last column in range
VBA
0 vote265 views1 answer
Vbscript abs
VBA
1 vote288 views1 answer
Vba loop through files in folder
VBA
0 vote262 views1 answer
Excel vba extract year
VBA
0 vote265 views1 answer
Vba line feed
VBA
0 vote284 views1 answer
Loop through lines in text file vb net
VBA