Multiple Worksheet_Change Events

nbdau7o · April 6th, 2015, 04:20 PM

In a single spreadsheet, can I use 2 different Worksheet_Change events? One to drive code in one tab and another Change event to drive code in another tab?
Private Sub Worksheet_Change(ByVal Target As Range)

nbdau7o · May 1st, 2015, 12:36 PM

I think the answer is no. you can only have one worksheet_Change events. I haven't heard a reply from anyone but I tried it out and don't think it liked me when I coded more than one.

DwightJackson · July 21st, 2015, 01:40 PM

Hey if you have more than one change in a worksheet then you must name them

Code:

Private Sub Worksheet_Change1(ByVal target As Range)

The Next one Would Say:

Code:

Private Sub Worksheet_Change2(ByVal target As Range)

In order to make it read these two you must Create another code that looks like this.

Code:

Private Sub Worksheet_Change(ByVal target As Range)

   Worksheet_Change1 target
   Worksheet_Change2 target

   End Sub

This will be the one it reads first. When it reads this one it will the work change 1 and 2. Hope this helps.