Run macro after data validation selection

[cybergremlin]

Hi

I have the below code working fine but i also need to run macros depending on another data validation list in cell Q7

Private Sub Worksheet_Change(ByVal Target As Range)
Application.Screenupdating = False
If Target.Address(True, True) = "$C$7” Then
Select Case Target
Case “1”
Call Macro1
Case “2”
Call Macro2
Case Else
Application.Screenupdating = True
End Select



End If
End Sub

How do i incorporate another data validation into the code?

thanks

 

[Fluff]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
   If Target.Address(0, 0) = "C7" Then
      Select Case Target
         Case "1"
            Call Macro1
         Case "2"
            Call Macro2
      End Select
   ElseIf Target.Address(0, 0) = "Q7" Then
      'do something
   End If
End Sub

 

[cybergremlin]

That worked perfect. I must of tried ElseIf everywhere apart from that line.

Thank you

 

[Fluff]

You're welcome & thanks for the feedback