Constant

[bopo]

Hi

Basically, I want to store a value that will never change using a constant, how do I do this?

[Tommy]

In a Module or bas file:
Public Const ShtLyr = "SHEETING"

The value of ShtLyr will contain "SHEETING" throughout the program.
:)

HTH

[Ken Puls]

Just for reference, if you can, I'd suggest declaring it as Private, instead of Public. This does mean that it would be available to that project only, though, so if you need to be able to call it from across modules, leave it as public.

[Bob Phillips]

Just for reference, if you can, I'd suggest declaring it as Private, instead of Public. This does mean that it would be available to that project only ...

That module only!

[Ken Puls]

Doh! :doh:

That's what I meant. Thanks for the correction. I still stand by the last half though..


so if you need to be able to call it from across modules, leave it as public.