ExcelBanter - Variable in more than one module

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Variable in more than one module (https://www.excelbanter.com/excel-programming/345053-variable-more-than-one-module.html)

Nick M[_3_]

Variable in more than one module

What is the best way to define a variable in one module and have it be held
constant in all other modules, fucntions, etc....?

Nick M.

K Dales[_2_]

Variable in more than one module

Define it as Public in the declarations section (top; before any subs or
functions) of the module it is in.
--
- K Dales

"Nick M" wrote:

What is the best way to define a variable in one module and have it be held
constant in all other modules, fucntions, etc....?

Nick M.

Nick M[_3_]

Variable in more than one module

that did it. Thanks!

"K Dales" wrote:

Define it as Public in the declarations section (top; before any subs or
functions) of the module it is in.
--
- K Dales

"Nick M" wrote:

What is the best way to define a variable in one module and have it be held
constant in all other modules, fucntions, etc....?

Nick M.

All times are GMT +1. The time now is 12:07 AM.