| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global module
Hi all
I need to define: Public RunWhen As Double and Public Const cRunIntervalSeconds = 120 '2 minutes in a Global module. How is that done? Could not find any info in the help. Many thanks Al |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Global module
A global module? I think this is just a standard module that doesn't have
Option Private Module specified (and by default it doesn't) -- Rob van Gelder - http://www.vangelder.co.nz/excel "Al" wrote in message ... Hi all I need to define: Public RunWhen As Double and Public Const cRunIntervalSeconds = 120 '2 minutes in a Global module. How is that done? Could not find any info in the help. Many thanks Al |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Global module
Hi Al
A Public variable declared outside a sub at the top of any normal code module is available to all other modules. regards Paul "Al" wrote in message ... Hi all I need to define: Public RunWhen As Double and Public Const cRunIntervalSeconds = 120 '2 minutes in a Global module. How is that done? Could not find any info in the help. Many thanks Al |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| global changes | Excel Worksheet Functions | |||
| CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
| arrays - module to module | Excel Programming | |||
| Variable from a sheet module in a class module in XL XP | Excel Programming | |||
Linear Mode
