Run Macro on cell change to "YES"

[cmb80]

Hi all, I have a macro that runs perfectly when a change is made using the data validation selection in column J.

The problem is I don't want the macro to run if "no" is selected from the drop down menu, only if "Yes" is selected.

What code do I need to add to the following:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("J:J")) Is Nothing Then
 
 
    Call Select_Macro
End If
 
     End Sub

 

[VoG]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("J:J")) Is Nothing Then
    If Target.Value = "Yes" Then Call Select_Macro
End If
End Sub

 

[prajul89]

If Range(target.Address).Value = "No" Then Exit Sub

just place this code on the top of your macro.

 

[cmb80]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("J:J")) Is Nothing Then
    If Target.Value = "Yes" Then Call Select_Macro
End If
End Sub

Works a treat - knew it would be straight forward just didn't know how to do it.

Thank you