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 vote204 views2 answers
Get excel file from email attachment in vba
VBA
0 vote227 views2 answers
Excel vba number format file size
VBA
0 vote207 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote230 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
3 votes212 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote195 views1 answer
Default host vbox address
VBA
0 vote232 views1 answer
Filesystemobject vba reference
VBA
3 votes202 views1 answer
Vba make long from two words
VBA
1 vote196 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
8 votes227 views1 answer
Vba make integer
VBA