Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Declaring variables in Module vs. Public
Hi,
I have written code and there are a number of variables that are declared at the top of the module - so they can be used by all subs in the module. I am expanding the code and am considering separating the new added code into a different module because it would be organized a little better. My question is - is there a performance difference to declaring the variables public rather then "Module" wide. Any advice under what circumstances to break code into different modules and when to declare public vs module wide. I have 1 module now, but I could break up the code into 6 modules that have product specific data. All the variables would have to change to public because they are common in the 6 modules. Thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
Declaring variables | Excel Discussion (Misc queries) | |||
Declaring variables | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Declaring a value to equal 100% | Charts and Charting in Excel |