Understanding conditional compilation
You can use conditional compilation to run blocks of code selectively, for example, debugging statements comparing the speed of different approaches to the same programming task, or localizing an application for different languages.
The following example runs debug code or production code, based on the value of the variable.
' Declare public compilation constant in Declarations section. #Const conDebug = 1 Sub SelectiveExecution() #If conDebug = 1 Then . ' Run code with debugging statements. . . #Else . ' Run normal code. . . #End If End Sub
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.