Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public Variables
Running XL 2003 in XP. I'm trying to share a variable between 2 subs,
each in a different module. Don't I just have to use the Public statement? Such as... Public dNTP as Date The first sub is in Module6 and calls the second sub in Module1. So I have the above statement in Module6. Any help is greatly appreciated. John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public Variables
At the top of Module 6, outside any sub or function put your declaration
Public dNTP as Date Should be visible to all modules in the same workbook. -- Regards, Tom Ogilvy wrote in message oups.com... Running XL 2003 in XP. I'm trying to share a variable between 2 subs, each in a different module. Don't I just have to use the Public statement? Such as... Public dNTP as Date The first sub is in Module6 and calls the second sub in Module1. So I have the above statement in Module6. Any help is greatly appreciated. John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
public variables | Excel Discussion (Misc queries) | |||
Public variables | Excel Discussion (Misc queries) | |||
Public Variables | Excel Discussion (Misc queries) | |||
Public Variables | Excel Programming | |||
Public Variables | Excel Programming |