[RESOLVED] Excel - Event on Embedded Check Box

I have added n Check Boxes to my Spreadsheet.

I need to be able to call procedures when one has it's value changed.

How do I reference a controls Click/Change event when it was added with code?

Could anyone help me out with this?

Create a Module with the procedure you want to fire on any action.

Code:

---

Selection.OnAction = "Module1.IPClick"

---

In your Module trap the caller

Code:

---

For Each myCheckBox in ActiveSheet.CheckBoxes
    If myCheckBox.Name = Application.Caller then ...
Next

---