Where do I place #CONST DEBUG_MODE = True in my workbook?

[stubbsj]

Hi -
I'm trying to use conditional complile and I am not sure where to place the following:

Please Login or Register  to view this content.

Currently, I have it declared at the top of "ThisWorkbook" object.

I want to be able to enable some MSGBOX lines throughout my workbook when I am developing but turn them all off when I release.

Thanks,
Jim

[jeffreybrown]

Hi Jim,

Try placing it at the top of a regular module

[stubbsj]

Thanks Jeff but that would require me to place it on every module and object. Is there a central place to declare the statement once so that it is available everywhere, i.e. a public decaration?

Jim

[royUK]

Declare it as Public

[shg]

From Help:

Conditional compiler constants are always Private to the module in which they appear. It is not possible to create Public compiler constants using the #Const directive. Public compiler constants can only be created in the user interface.

To declare in the UI, from the VBE, Tools > VBA Project Properties, Conditional Compiler Arguments:

DEBUG_MODE = 1: SomeOtherConstant=0: SomeThirdConstant=42

Values can only be Integers.

[stubbsj]

Thanks Roy but

Please Login or Register  to view this content.

doesn't work.

This all works if I use the #CONST DEBUG_MODE = True on every Module, Form, & Object. Unfortunately, that would require me to set the variable to False for every Module, Form, & Object.

I was asking is there ONE place where I could place the statement for the entire workbook?

[stubbsj]

Thanks shg. That worked and I learned someting new.

Jim (From Texas too)