| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in more than one module
What is the best way to define a variable in one module and have it be held
constant in all other modules, fucntions, etc....? Nick M. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in more than one module
Define it as Public in the declarations section (top; before any subs or
functions) of the module it is in. -- - K Dales "Nick M" wrote: What is the best way to define a variable in one module and have it be held constant in all other modules, fucntions, etc....? Nick M. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in more than one module
that did it. Thanks!
"K Dales" wrote: Define it as Public in the declarations section (top; before any subs or functions) of the module it is in. -- - K Dales "Nick M" wrote: What is the best way to define a variable in one module and have it be held constant in all other modules, fucntions, etc....? Nick M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| STATIC VARIABLE NOT AVAILABLE IN ANOTHER MODULE | Excel Discussion (Misc queries) | |||
| Assign Value to Module Level Variable | Excel Programming | |||
| Variable in event handles can't be used in module?? | Excel Programming | |||
| Variable from a sheet module in a class module in XL XP | Excel Programming | |||
| module-level variable lifetime | Excel Programming | |||
![Nick M[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
