ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Public variables and Class (https://www.excelbanter.com/excel-programming/294578-public-variables-class.html)

Aidy

Public variables and Class
 
I've got a logit function in a class

<snip

Write #FileNumber, lLogNum, sLogText

<snip

lLogNum is a number that increments every time the method is called

oLog.Log "Test"

lLogNum has a scope of Public

Now in the log file I get
1. test
2. test

However when I instantiate the class in a new module, lLogNume resets itself,
and I get
1. test
2. test

When what I need is
3. test
4. test

Any ideas?

Cheers

Aidy

Bob Phillips[_6_]

Public variables and Class
 
Instantiating a class creates a new instance of that object, so in effect
you have a new iLogNum.


What you need to do is to declare iLogNum as a public variable in a standard
code module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Aidy" wrote in message
om...
I've got a logit function in a class

<snip

Write #FileNumber, lLogNum, sLogText

<snip

lLogNum is a number that increments every time the method is called

oLog.Log "Test"

lLogNum has a scope of Public

Now in the log file I get
1. test
2. test

However when I instantiate the class in a new module, lLogNume resets

itself,
and I get
1. test
2. test

When what I need is
3. test
4. test

Any ideas?

Cheers

Aidy





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

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