Validation Lists and Macros

I have a macro that runs when I click on three different validation lists (code below). I now have another validation list (at G9) that I need to run 5 seperate macros depending on the validation list selection...how can I add to the below code so this functions properly? Thx


Private Sub Worksheet_Change(ByVal Target As Range)

'Do nothing if more than one cell is changed or content deleted
If Target.Cells.Count > 1 Then Exit Sub

If Not Intersect(Target, Range("G3,G5,G7")) Is Nothing Then
Call RefreshPandL
End If

End Sub



Any Thoughts?

Hi Pony08

Please use Code Tags around your Code...it's a Forum Requirement. To do so, in your Original Post, highlight your code and click the # icon at the top of your post window.

If I understand your issue try this

Please Login or Register  to view this content.