SuperQuick Q: Constants...?

[ClimoC]

So a Const/#Const only work as Private compiler constants... ie, for the module within which they reside.

Can I have a Public compiler constant at all?

Essentially, before every script in my 20 modules and forms runs, I want it to obtain the value from Sheet3, Cell E2

I would've thought #Const SecLvl = Sheets("GridData").Range("E2").Value or a variation thereof would work, but apparently not. Unrecognised, invalid, wrong syntax, you name it, I've gotten an error for it.

Any help as to how I can do this? Or do I have to Global my integer and then set the value at runtime with a line like 'SecLvl = Sheets("GridData").Range("E2").Value' etc

Thanks
C

 

[Firefly2012]

If you assign a value to a Constant based on a worksheet cell it's not really a constant. So you are correct that an alternative would be to use a Global variable and assign at runtime.

 

[ClimoC]

Thanks FireFly.

I sort of figured as much, as the two ideas do sort of contradict each other - but had just wondered if a variable could at least be declared as always Cell E2 of sheet 3 etc...

S'only one extra line of code... heck... the book has 10,000....