View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
R Avery R Avery is offline
external usenet poster
 
Posts: 220
Default Interfaces for VBA Forms

Interesting... I did not know any of this. Thanks a lot.


Stephen Bullen wrote:

Hi R,


Interfaces support event, correct?



No, in VBA6 we can only raise events declared in a class's default
interface - we can't raise events declared in an Implemented interface.


So if a class cannot raise an event
for the interface that it implements, how do the interface events get
raised?



They don't!

That said, if you're willing to hack around the binaries, Matt Curland has
explained how it can be done:
http://groups.google.com/groups?selm...%40tkmsftngp12

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie