ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Variables (https://www.excelbanter.com/excel-programming/303622-variables.html)

No Name

Variables
 
Is it possible to set a variable in one module and use it
in another module?

Mark Wielgus

Variables
 
set the variables scope to Public and declare it outside of a sub or functions. for example:

at the top of 1 module put
Public MyVariable as integer

you should be good to use it anywhere now.

" wrote:

Is it possible to set a variable in one module and use it
in another module?


No Name

Variables
 

Thank You!!



-----Original Message-----
set the variables scope to Public and declare it outside

of a sub or functions. for example:

at the top of 1 module put
Public MyVariable as integer

you should be good to use it anywhere now.

" wrote:

Is it possible to set a variable in one module and use

it
in another module?

.



All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com