| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Global Variables in a module
Is it possible to set variables for access to all sub routines and functions within a module?
eg. pathB = ThisWorkbook.Path is refer to this in many sub routines Bruce |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Global Variables in a module
Bruce,
Declare the variable outside of a macro, at the start of the module. They can then be set/read from any procedure in that module. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Bruce" wrote in message ... Is it possible to set variables for access to all sub routines and functions within a module? eg. pathB = ThisWorkbook.Path is refer to this in many sub routines Bruce |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Global module | Excel Programming | |||
| Global variables cleared by forms? | Excel Programming | |||
| Global Variables using User Forms | Excel Programming | |||
| Global Variables Not Accessible | Excel Programming | |||
| Declaring Global Variables | Excel Programming | |||
Linear Mode
