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

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

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