ExcelBanter

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

Man from Utopia

Static Variables
 
I'm struggling withvariables declared with the Static keyword seemingly
reinitialising themselves. My code DOES jump from module to module, but I
need to declare several arrays which will retain whatever values I write to
them until I close the application.

I guess I'm missing something obvious?

Brian Henstock

mg[_3_]

Static Variables
 
Sun, 8 Aug 2004 13:07:02 -0700, Man from Utopia wrote :

I'm struggling withvariables declared with the Static keyword seemingly
reinitialising themselves. My code DOES jump from module to module, but I
need to declare several arrays which will retain whatever values I write to
them until I close the application.

I guess I'm missing something obvious?


Did you declare all variables as *Static Public* ?

--
Immortal under the Sun are the gods alone,
As for mortals their days must end -
What they achieve is but the wind!
Gilgamesh ,T2

Chip Pearson

Static Variables
 
Did you declare all variables as *Static Public* ?

There is no such declaration as "Static Public". Public
variables are by definition static.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"mg" wrote in message
...
Sun, 8 Aug 2004 13:07:02 -0700, Man from Utopia wrote :

I'm struggling withvariables declared with the Static keyword

seemingly
reinitialising themselves. My code DOES jump from module to

module, but I
need to declare several arrays which will retain whatever

values I write to
them until I close the application.

I guess I'm missing something obvious?


Did you declare all variables as *Static Public* ?

--
Immortal under the Sun are the gods alone,
As for mortals their days must end -
What they achieve is but the wind!
Gilgamesh ,T2




mg[_3_]

Static Variables
 
Sun, 8 Aug 2004 17:03:57 -0500, Chip Pearson wrote :

There is no such declaration as "Static Public". Public
variables are by definition static.


Ah yes


All times are GMT +1. The time now is 07:18 PM.

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