Locating cell change event handler

J

John

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
 
N

Norman Jones

Hi John,

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

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

Pass value variable to worksheet event 3
Change Event (How post Date/Time to Changed Cells Rows but different Column) 7
Have Cell To Left Show Fixed Time When Cell Changes 5
Need a accumulator driven from second cell 4
Simple Copy Paste within Worksheet Change Event 2
Worksheet Change Event Refuses to Action 3
Change event code Find .Activate does not activate Target.value 4
How to set up a delay to Private Sub Worksheet_Change(ByVal TargetAs Range) event 6

Top