Used to define conditional compiler constants for Visual Basic.
#Const constname = expression
The #Const compiler directive syntax has these parts:
|constname||Required; Variant (String). Name of the constant; follows standard variable naming conventions.|
|expression||Required. Literal, other conditional compiler constant, or any combination that includes any or all arithmetic or logical operators except Is.|
Conditional compiler constants are always Private to the module in which they appear. It is not possible to create Public compiler constants by using the #Const directive. Public compiler constants can only be created in the user interface.
Only conditional compiler constants and literals can be used in expression. Using a standard constant defined with Const, or using a constant that is undefined, causes an error to occur. Conversely, constants defined by using the #Const keyword can only be used for conditional compilation.
Conditional compiler constants are always evaluated at the module level, regardless of their placement in code.
This example uses the #Const directive to declare conditional compiler constants for use in #If...#Else...#End If constructs.
#Const DebugVersion = 1 ' Will evaluate true in #If block.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.