Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global Constants?
Can constants be declared globally, that is to be used in
all modules? If so, where should the constant be defined? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global Constants?
Hi
declare them at the beginning of one module and you can use them in your project -- Regards Frank Kabel Frankfurt, Germany "Bob" schrieb im Newsbeitrag ... Can constants be declared globally, that is to be used in all modules? If so, where should the constant be defined? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global Constants?
And don't use Dim, use Public.
Public myString As String Frank Kabel wrote: Hi declare them at the beginning of one module and you can use them in your project -- Regards Frank Kabel Frankfurt, Germany "Bob" schrieb im Newsbeitrag ... Can constants be declared globally, that is to be used in all modules? If so, where should the constant be defined? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flagging constants | Excel Worksheet Functions | |||
constants | Excel Discussion (Misc queries) | |||
constants | Excel Programming | |||
Color constants in VBA | Excel Programming | |||
How to set global constants and get path of spreadsh ? | Excel Programming |