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

 

[ybolotin]

I think what the person in question was looking for was:

replace
Const variable_name = some_value

with
Public variable_name as variable_type

and then give it a value in the code.
this way all functions and subs have access to it.