VBA to do a range of different tasks from a drop down list

[danbates]

Hi,

I was wondering if someone could help me please?

I would like someone to help me alter this code:

    If Target.Column <> 5 Then Exit Sub  
    If Target.Value = "Azera" Or Target.Value = "N" Or Target.Value = "L" Or Target.Value = "M" _
    Or Target.Value = "K" Or Target.Value = "H" Or Target.Value = "J" Or Target.Value = "n" _
    Or Target.Value = "l" Or Target.Value = "m" Or Target.Value = "k" Or Target.Value = "h" Or Target.Value = "j" Then
    
      MES_ASA.Show
   
    Else
  
        Range("K" & Target.Row).Value = "N/A"
   
  If Target.Value = "" Then
  Target.Offset(0, 6) = ""
  
    End If
    End If

When I select a letter from the drop down list in column E (Azera, D, E, F, G, H, J, K, L, M, N, P) I want the code to check column F value before triggering the userform.

If column F value is 0 then I want a message box to say "Invalid answer, please choose again" and when the message box is OK'd I would like column E&F to clearcontents.

If column F value is greater than 0 then let the userform trigger as normal.

Any help would be much appreciated.

Kind Regards

Dan