VBA Constant

[edvwvw]

Is there any way that I can change a constant in VBA

Option Explicit
Const MaxAccuracy = 0.00001
Const MaxLoops = 100
Constant Reset = 900

I want to be able to change the Reset constant to 900 or 3600.

The variable is called over 20 times within the code so if possible I would rather use the Option Explicit rather than make all of the entries using Public Function for each area of the module.

Any help would be greatly appreciated - thanks

edvwvw

[Lewiy]

If you have a value that you want to change throughout the code, why don’t you just declare it as a variable rather than a constant?

FYI – Option Explicit just forces all variables and constants to be declared. It has no bearing on where or how they are defined.

[edvwvw]

Thanks - I will try that instead

edvwvw