Change Event with Drop Down Validation List

[gophins]

Hi, I have 13 sheets in my workbook (one for each month plus a GlobalSettings). In each month sheet I want to create a change event that prompts a UserForm when they select "Yes" from a drop-down validation list if it happens to be a month prior to the current month. However it is not working, any help will be greatly appreciated!!!

This is the code for the change event:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Value1, Value2 As Integer
    Value1 = Sheets("P1").Range("I15").Value
    Value2 = Sheets("GlobalSettings").Range("B14").Value
    If Target.Address = "$K$14" Then
        If Range("K14") = "NO" Then
        End If
        Exit Sub
        If Range("K14") = "YES" And Value1 < Value2 Then
        UserForm2.Show
        End If
    End If
End Sub