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

Vba Ignore Case

[Solved] Vba Ignore Case | 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 ignore case

Code Explorer Popular Question For Vb