+ Reply to Thread
Results 1 to 7 of 7

Lifetime and class modules

Hybrid View

  1. #1
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    I've tried similar things. I've declared a public objectCount variable in a normal module together with
    Private Sub Class_Initialize()
    objectCount = objectCount + 1
    End Sub
    
    Private Sub Class_Terminate()
    objectCount = objectCount - 1
    End Sub
    The results have not been what I expected. I'm not sure if the counting technique flawed or my expectations are wrong.

    The technique in the previous posts was used to create a "null" for my class, but (as you noted) it's constant.

    Good luck with the problem.

  2. #2
    Registered User
    Join Date
    01-16-2007
    Location
    Near the box
    Posts
    58
    Just solved. Works great ! I'll provide my solution later.
    ? ? ? I like the way how Excel can access system API. Really cool ! ? ? ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1