View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aidy Aidy is offline
external usenet poster
 
Posts: 1
Default 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