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 vote80 views1 answer
How to set location and size of new from vb
VBA
4 votes80 views1 answer
Excel vba determine number of elements in an array
VBA
4 votes90 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
1 vote78 views1 answer
Excel vba to lower case
VBA
3 votes92 views1 answer
Vba http request json
VBA
-1 vote75 views1 answer
Text to speech vb.net
VBA
18 votes189 views3 answers
Excel-vba make integer
VBA
0 vote87 views1 answer
Average vba
VBA
0 vote86 views1 answer
Vba loop through textboxes
VBA
0 vote80 views1 answer
Change "location" of binding navigator vb
VBA