Table of contents
TOC
Collapse the table of content
Expand the table of content

Comparison Constants

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

The following constants are defined in the Visual Basic for Applicationstype library and can be used anywhere in your code in place of the actual values:

ConstantValueDescription
vbUseCompareOption-1Performs a comparison using the setting of the Option Compare statement.
vbBinaryCompare0Performs a binary comparison.
vbTextCompare1Performs a textual comparison.
vbDatabaseCompare2For Microsoft Access (Windows only), performs a comparison based on information contained in your database.
© 2017 Microsoft