View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default events across vba projects

Are you talking about receiving standard Excel events (e.g.,
Change, SelectionChange) from another workbook? If so, you need
to use Application level events. See
http://www.cpearson.com/excel/AppEvent.htm for details and
example code.

Or are you talking about custom, user defined events, declared as
Event and triggered by RaiseEvent?

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Eric Fingerhut" wrote
in message
...
Is this possible?

I have a core library (vba project, "LibA") that I want to be
ignorant of
any consumers. If I set up a separate project ("LibB") that has
a reference
set to "LibA", there are times when I may like to make a piece
of
information available from LiibB to LibA.

I thought the natural solution would be to set up an event that
broadcasts
the need for information in LibA, with and event handler in
LibB to provide
it. Doing so compiles, but doesn't seem to work.

TIA,
Eric