VBA Event handlers in dolphin

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

VBA Event handlers in dolphin

Oli Bye-3
Has anybody used Dolphin to be notified of VBA events?

I'm trying to catch a SheetChanged event in Excel 9.0, and I was
expecting an onSheetChanged selector I could use somewhere. But I'm
now not sure this is a vanila COM event. I think it's a VBA event
which is different?

The ActiveX Component Wizard creats the ExcelIAppEvents interface I'm
interested in using. But I can't see how to register event handlers.

Anybody any ideas?

Oli
Bye
Dolphin 4.1 Std


Reply | Threaded
Open this post in threaded view
|

Re: VBA Event handlers in dolphin

Oli Bye-3
 From a previous post (and a little help from the wonderful debugger),
it looks like I can do what I want using AXEventSink

I shall examine the AgentChat example for more detail in the morning!

Oli
Bye