The Terminate event for a class module occurs when all references to an instance of that class are removed from memory. To run code when the Terminate event occurs, you must place that code within the Terminate event procedure in a class module.
Private Sub Class_Terminate( )
This event occurs only when you remove a reference to an instance of a class from memory.