On Change

E

Erich Neuwirth

I need to write an addin which contains a class module.
Each class instance will have a range as one of its properties,
and these ranges will come from other workbooks, not from the addin.
The object will need to run a method (aka subroutine)
when a cell in the associated range changes.
How can I acomplish that, with an On_Change event
or with another technique?
It will probably not be possible to add code
to the workbook containing the range, all code should be in the addin.
 
J

Jim Rech

You're going to have to create an application level event handler.

http://support.microsoft.com/default.aspx?scid=kb;en-us;213566&Product=xlw

--
Jim Rech
Excel MVP
|I need to write an addin which contains a class module.
| Each class instance will have a range as one of its properties,
| and these ranges will come from other workbooks, not from the addin.
| The object will need to run a method (aka subroutine)
| when a cell in the associated range changes.
| How can I acomplish that, with an On_Change event
| or with another technique?
| It will probably not be possible to add code
| to the workbook containing the range, all code should be in the addin.
|
|
 
Top