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 vote199 views1 answer
Excel web scraping
VBA
0 vote228 views1 answer
Excel vba delete columns in range
VBA
0 vote164 views1 answer
Vba apostrophe chr
VBA
0 vote185 views1 answer
Type excel.application is not defined vb
VBA
0 vote179 views1 answer
Vba len variant
VBA
-1 vote171 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote189 views1 answer
Reference to a non-shared member requires an object reference
VBA
8 votes200 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote167 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote187 views1 answer
How to use if condition in time vba
VBA