Multiple change events

[MrPez]

I've got a problem with change events...

At the minute I have a worksheet that triggers a macro when the value of a certain cell changes. It works fine, and the code is:


Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Row = 2 And Target.Column = 1 Then
call module1.import
End If
End Sub


My problem is that I am trying to set up the same again that watches another cell and when that value changes it calls a different module. I've tried calling it something like
Private Sub Worksheet_Change2(ByVal Target As Excel.Range)
to make it different from the first but it just does nothing. Can you only have one change event per worksheet/workbook? If so, can anyone think of a way around this?

Thanks in advance...
Pez

[DonkeyOte]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here