On Change

  • Thread starter Thread starter Erich Neuwirth
  • Start date Start date
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.
 
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.
|
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COM addin won't connect when workbook opened via another workbookfrom another instance 3
Copy a Sheet to an AddIn 2
When Class object get created 2
Addin conflicting with Workbook Module 3
Add-in Question (common code) 2
Custom Addin Reference Crashes Excel 6
Addins attached only to selected workbook(s)?? 5
can we copy the code from the addin to excel workbook 1

Back
Top