In the class module use the object_Initialize event, e.g.:

Private Sub Class_Initialize()
'Do something
End Sub

In article ,
vivmaha wrote:

How do i make a constructor in VBA?
I search one the web and help for 'constructor' but found nothing.

Thanks.