ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Global Constants? (https://www.excelbanter.com/excel-programming/309816-global-constants.html)

bob

Global Constants?
 
Can constants be declared globally, that is to be used in
all modules? If so, where should the constant be defined?

Thanks!



Frank Kabel

Global Constants?
 
Hi
declare them at the beginning of one module and you can use them in
your project

--
Regards
Frank Kabel
Frankfurt, Germany

"Bob" schrieb im Newsbeitrag
...
Can constants be declared globally, that is to be used in
all modules? If so, where should the constant be defined?

Thanks!




Dave Peterson[_3_]

Global Constants?
 
And don't use Dim, use Public.

Public myString As String



Frank Kabel wrote:

Hi
declare them at the beginning of one module and you can use them in
your project

--
Regards
Frank Kabel
Frankfurt, Germany

"Bob" schrieb im Newsbeitrag
...
Can constants be declared globally, that is to be used in
all modules? If so, where should the constant be defined?

Thanks!



--

Dave Peterson



All times are GMT +1. The time now is 12:28 PM.

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