Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |