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 vote279 views1 answer
Vba argument is set
VBA
0 vote299 views1 answer
Get current year vb
VBA
0 vote311 views1 answer
Iterate all file in a folder vba
VBA
0 vote318 views1 answer
Make your computer talk vbscript
VBA
0 vote322 views1 answer
Vba search string position
VBA
0 vote313 views1 answer
Vba find last column in a row with data
VBA
0 vote290 views1 answer
Vba find sub dictionary
VBA
0 vote307 views1 answer
Find database connection string vb
VBA
0 vote307 views1 answer
Group controls programmatically vb
VBA
0 vote300 views1 answer
Send text to clipboard vb.net
VBA