Class module constructors

V

vivmaha

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

Thanks.
 
J

JE McGimpsey

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

Private Sub Class_Initialize()
'Do something
End Sub
 
V

vivmaha

Hi, this did not work.

Thanks.

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

Private Sub Class_Initialize()
'Do something
End Sub
Click to expand...
 
C

Chip Pearson

What does "did not work" mean? The Class_Initialize procedure is within the
class module and is automatically called when an instance of the class is
created. VBA does not allow for alternate constructors.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
V

vivmaha

Sorry.

When he said "Class_Initialize" i assumed I had to put the class name where
"class" was.

I put "Class_Initialize" and it worked.

Thanks.

Also, is there a destructor in VBA?
 
C

Chip Pearson

Also, is there a destructor in VBA?

The Terminate method is called when the class is destroyed.

Private Sub Class_Terminate()
' your code here
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
V

vivmaha

great.

thanks.

Chip Pearson said:
The Terminate method is called when the class is destroyed.

Private Sub Class_Terminate()
' your code here
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

new v/s createObject ... IXMLDOMNodeList 0
Constructors for Classes 3
VBA and Constructors; exist? 2
Visio "A non-abstract class cannot have abstract operations" ? 1
RTD methods in excel called before workbook_open event 0
Question with Excel Automation Add-in 0
Delegate constructor compiles in VB.NET, but not in Excel VBA 0
pass value to excel userform - is there a constructor? how to pass 6

Top