Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, i am sure a simple answer, but if i declare a public variable in the
first or "Start module", does that surfice for the whole project or must one declare it in each module? Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
a public variable declared in a general module should be visible throughout
the workbook/project. Declaring it anywhere else will hide it in the location where it is declared again. (this assumes the module is public, but that is the default). -- Regards, Tom Ogilvy "Les Stout" wrote in message ... Hi, i am sure a simple answer, but if i declare a public variable in the first or "Start module", does that surfice for the whole project or must one declare it in each module? Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA - variable declaration | Excel Discussion (Misc queries) | |||
Public declaration | Excel Programming | |||
External Variable Declaration | Excel Programming | |||
public declaration | Excel Programming | |||
Variable Declaration?? | Excel Programming |