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

Thanks.

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.

Hi, this did not work.

Thanks.

"JE McGimpsey" wrote:

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.

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)


"vivmaha" wrote in message
...
Hi, this did not work.

Thanks.

"JE McGimpsey" wrote:

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.

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?

"Chip Pearson" wrote:

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)


"vivmaha" wrote in message
...
Hi, this did not work.

Thanks.

"JE McGimpsey" wrote:

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.

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)


"vivmaha" wrote in message
...
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?

"Chip Pearson" wrote:

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)


"vivmaha" wrote in message
...
Hi, this did not work.

Thanks.

"JE McGimpsey" wrote:

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.