1878026431
My application needs to use some classes that are declared in an Add-In. Can
I create in my application the objects (instances) of these classes? VBA
allows to set instancing type for a class module to 1 (Private) or 2
(PublicNotCreateable). Can I use any other instancig model in VBA?

Thanks for answers
Dmitry Petkun

Dmitry,

VBA supports only Private or PublicNotCreateable classes. Therefore, your
application cannot create objects based on classes in another project. You
can add a procedure to your add-in that will create and return a new
instance of the class. For example,

' in your add-in
Public Sub CreateClassObject() As Class1
Set CreateClassObject = New Class1
End Sub

' in your application
Dim C As AddInProject.Class1
Set C = AddInProject.CreateClassObject()


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Dmitry V. Petkun" wrote in message
...
1878026431
My application needs to use some classes that are declared in an Add-In.
Can
I create in my application the objects (instances) of these classes? VBA
allows to set instancing type for a class module to 1 (Private) or 2
(PublicNotCreateable). Can I use any other instancig model in VBA?

Thanks for answers
Dmitry Petkun

What kind of instancing do you require?

"Dmitry V. Petkun" wrote in message ...
1878026431
My application needs to use some classes that are declared in an Add-In. Can
I create in my application the objects (instances) of these classes? VBA
allows to set instancing type for a class module to 1 (Private) or 2
(PublicNotCreateable). Can I use any other instancig model in VBA?

Thanks for answers
Dmitry Petkun