Classes

With VBA class modules we can create our own reusable objects.
A good introduction into VBA classes you can find at Chip Pearson's website.
During my 30 years of Excel practice I have encountered some very useful classes which I like to present here:
​SystemState - This one I am using in almost all of my serious VBA applications to speed up my code.
​Logging - This class is very useful if you like to document each execution (run) of your VBA code.
​Performance - (just a useful link) Sometimes I need to analyse where my code is spending its time.
​
​
​

Sample Application

Logging

Last modified 11mo ago

Copy link