1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Vba Remove Case Sensitivity

[Solved] Vba Remove Case Sensitivity | Vb - Code Explorer | yomemimo.com
Question : vba Remove Case Sensitivity

Answered by : vastemonde

'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 : | Last Update : Sat, 30 Jan 21

Question : vba ignore case

Answered by : vastemonde

'Removes case sensitivity
Option Compare Text	' a < B
'Adds case sensitivity
Option Compare Binary	' A < B < a < b
'Compare
Debug.Print StrComp(string1, string2, vbUseCompareOption) 'Microsoft Access only
Debug.Print StrComp(string1, string2, vbBinaryCompare) 'case sensitive
Debug.Print StrComp(string1, string2, vbTextCompare) 'case insensitive

Source : https://www.oreilly.com/library/view/vb-vba/1565923588/1565923588_ch07-1677-fm2xml.html | Last Update : Sat, 30 Jan 21

Answers related to vba remove case sensitivity

Code Explorer Popular Question For Vb