+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    keithb
    Guest

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

    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



  2. #2
    Tushar Mehta
    Guest

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

    In article <eVD4TnZtFHA.208@TK2MSFTNGP10.phx.gbl>, k31thb@yahoo.com
    says...
    > 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
    >
    >
    >

    How to use a class (object) from outside of the VBA project in which it
    is declared
    http://support.microsoft.com/default...b;en-us;555159

    --
    Regards,

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1