Help with VB Code Please :)

[Jay3]

Hi All,

Can someone help me tweak this macro to get it to work for me?

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Cells.Count > 1 Then Exit Sub
    If Not Application.Intersect(Range("A1"), Target) Is Nothing Then
        If IsNumeric(Target.Value) And Target.Value > 200 Then
            Call Mail_small_Text_Outlook
        End If
    End If
End Sub

The above is the closest example of what I want but I need to simplify it. I just need the macro to start at F2 and do the following.

If someone selects "YES" from the drop down menu in F2 than I want it to call another macro if someone selects "No" then exit.

Each time someone adds a new row of data to the worksheet the macro needs to pick up if "Yes" has been selected in F3 for example and ignore the "Yes" in the previous row.

i.e. the macro is to work only once for each new record.

Can anyone help with this?

Thanks,
Jay3

 

[Jay3]

can anyone help?