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

1 vote287 views1 answer
Vba optional
VBA
1 vote276 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote316 views1 answer
Windows Forms dark title bar
VBA
31 votes384 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote278 views1 answer
Vb.net change cursor to wait
VBA
0 vote283 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote290 views1 answer
Vb get ip address
VBA
0 vote298 views1 answer
Excel vba combine ranges
VBA
1 vote311 views1 answer
Find and replace textbox
VBA
0 vote309 views2 answers
Vb.net include quotes in string
VBA