• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Class module usage

JesseH77

New Member
Does anyone have a good breakdown of why you would use a class module? I'm good with the how, just not the why. Since the collection isn't static you have to read all the members back in each time the sheet is opened. How is this much different than reading an array into memory and using regular modules? Is it functionally the same just a better organizational structure?


Jesse
 
Normally a class module would be used to abstract a specific part of the design. Say for instance that you wanted to create a custom object that would be used throughout your code. You would create a class with all of the required methods and properties, test this within a simple test harness. You can then incorporate it in your application without worrying about its internals, just as long as you have a clearly defined interface.
 
Back
Top