Answers for "vba Remove Case Sensitivity"

VBA
1

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
Posted by: Guest on January-23-2021
3

vba ignore case

'Removes case sensitivity
Option Compare Text			' a < B
'Adds case sensitivity
Option Compare Binary		' A < B < a < b
'Compare
Debug.Print StrComp(string1, string2, vbUseCompareOption) 'Microsoft Access only
Debug.Print StrComp(string1, string2, vbBinaryCompare)	  'case sensitive
Debug.Print StrComp(string1, string2, vbTextCompare)      'case insensitive
Posted by: Guest on January-23-2021

Code answers related to "VBA"

Browse Popular Code Answers by Language