Locating cell change event handler

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 22 Jan 2006 01:29 GMT

I have a workbook w/ 10 or so sheets and I want to put in an event handler
to call different macros if different cells are changed by the user. For
testing I've tried putting the following routine in one and all of Modules
1-5 of the workbook project, but can't seem to get it triggered. What am I
doing wrong?

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
MsgBox "Range " & Target.Address & " was changed."
End Sub

Reply to this Message

Norman Jones - 22 Jan 2006 01:44 GMT

Hi John,

Worksheet event procedures should be placed in the sheet module -right-click
the sheet tab, View Code.

---
Regards,
Norman

>I have a workbook w/ 10 or so sheets and I want to put in an event handler
> to call different macros if different cells are changed by the user. For
[quoted text clipped - 5 lines]
> MsgBox "Range " & Target.Address & " was changed."
> End Sub

Reply to this Message