How to reference a Class Module located in an add-in or another workbook?

  • Thread starter Thread starter keithb
  • Start date Start date
K

keithb

This statement:

Dim AppClass As New EventClass

Works properly if the EventClass Class module is located the in the same
workbook. It does not work properly if the EventClass module is located in
an Add-in file or in another open workbook. How can I refer to EventClass
when its Class Module is located in an Add-in file, or in another open
workbook?

Thanks,

Keith
 
This statement:

Dim AppClass As New EventClass

Works properly if the EventClass Class module is located the in the same
workbook. It does not work properly if the EventClass module is located in
an Add-in file or in another open workbook. How can I refer to EventClass
when its Class Module is located in an Add-in file, or in another open
workbook?

Thanks,

Keith
Click to expand...
How to use a class (object) from outside of the VBA project in which it
is declared
http://support.microsoft.com/default.aspx?scid=kb;en-us;555159

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top