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 vote257 views1 answer
Vba code for cutoff time
VBA
0 vote231 views1 answer
Write listbox to text file vb.net
VBA
0 vote249 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote225 views1 answer
Change form background image vb
VBA
0 vote243 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
2 votes169 views1 answer
Excel vba pause
VBA
3 votes247 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote215 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote230 views1 answer
Worksheet.pastespecial textbox
VBA
1 vote209 views2 answers
Get all column names from excel vba
VBA