worksheet change macros inconsistant

[tjlaser shepard]

I have the following macros set up in one worksheet "code-behind" page to call other macros when specific cells are changed:

---------------------------------------------------
Private Sub worksheet_change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("B9")) Is Nothing Then Call LimitRigDropdown
End Sub

-----------------------------------------------------
Private Sub worksheet_change2(ByVal Target As Range)
If Not Intersect(Target, Me.Range("E9")) Is Nothing Then Call unhideList
End Sub
-----------------------------------------------------

the first one works, but I can't get the second to trigger. I know it's not a problem with the unhideList macro because I used a STOP after the inner "if" statement to check if the event handler is even triggered (it isn't). Is there any reason why only one of these would work?

TIA

 

[JoeMo]

You can only have one change event macro in a worksheet. The _change2 is not valid as a change event macro. You can combine the two like this:

Private Sub worksheet_change(ByVal Target As Range)
    If Not Intersect(Target, Me.Range("B9")) Is Nothing Then Call LimitRigDropdown
If Not Intersect(Target, Me.Range("E9")) Is Nothing Then Call unhideList
End Sub

 

[tjlaser shepard]

Thanks Joe

 

[JoeMo]

You are welcome - thanks for the reply.