'#define' equivalent in VBA?

[Phil_V]

Does VBA support an equivalent to C's "#define" for inline replacement?

For example I have a section of code, where a tollerance is allowed, and the tollerance could be either a fixed tollerance or a percentage tollerance, that I would like to be able to change at a later date:

Please Login or Register  to view this content.

Then at the top of the file I could have:

Please Login or Register  to view this content.

Which would cause the line in the original code to be evaluated as:

Please Login or Register  to view this content.

Alternatively I could have at the top of the file:

Please Login or Register  to view this content.

Which would cause the line in the original code to be evaluated as:

Please Login or Register  to view this content.

Is something like this possible with VBA?
Otherwise I can only see doing it with booleans and a 'value' parameter, so requiring code something like this:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Then a 'main' code of:

Please Login or Register  to view this content.

but as I have several of these tollerances for different things, and each one is in multiple places in the file the first method would be tidier and easier to up-keep..... if it is possible?

Thanks

[Andy Pope]

No #Define equivalent.

VBA as # conditional complilation syntax but that would still require you to test a condition in order to add or multiple the value of TOLLERANCE

Please Login or Register  to view this content.

In order to set the condition of TOLLERANCE_IS_FIXED you would need to display the VBA project dialog.
In VBE use menu Tools > [I]projectname[I] properties...
Conditional complication arguments.

TOLLERANCE_IS_FIXED = 1

[Phil_V]

Cheers for the reply Andy. That's a shame to hear that there is no equivalent, I guess I'll be doing it with IF statements (of one sort or another) after all then