Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object Module Constants Scope
I hope my terminology is correct: I have some object modules (button clicks) in which I want to some project wide constants - which will be used in many places. What is the suggested tidy way to do this without declaring the constants twice in the object module and code module. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object Module Constants Scope
Declare them as Public variables in a standard code module.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "griff" wrote in message ... I hope my terminology is correct: I have some object modules (button clicks) in which I want to some project wide constants - which will be used in many places. What is the suggested tidy way to do this without declaring the constants twice in the object module and code module. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Sheet Object Module | Excel Programming | |||
Pass worksheet object name to a class module | Excel Programming | |||
Declaring array constants at module level | Excel Programming | |||
variable scoping - constants going out of scope - circular references | Excel Programming | |||
Class Module Scope | Excel Programming |