+ Reply to Thread
Results 1 to 2 of 2

VBA not seeing Events from 3rd party control

  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    Michigan
    Posts
    68

    VBA not seeing Events from 3rd party control

    Excel 7
    I have a Library that I load into Excel as a reference(.dll) The library exposes 3 controls that can be placed on a form in VBA. 2 of the controls raise events as expected(the events are raised from the library that is talking to an external device) 1 of the controls allows me to set properties and send data tto the Library, it does not raises events. The manufacturer states that Excel is blocking the Events. This seems to be true, because it all works fine in VB6 VB.net C++ and most other languages. To add another caveat, the control will not allow me to send data unless I create a reference to the original control. So the question is, does anyone know why Excel would block messages from a DLL?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: VBA not seeing Events from 3rd party control

    Hello excelbobabc,

    This is first time I have heard of Excel "blocking" events. Provided the controls in your DLL are COM compliant, there should not be any problems communicating with Excel. More likely the problem lies with the interface between the DLL and VBA. I would press the third party for more information. They may, in fact, not know why but I would ask.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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