Need pop up from drop down menu - can't figure out how to fix my code

[synthesis45]

I can't seem to figure out the exact need for my excel sheet. I have a sheet that has drop down menus in B5:AF25. There are many choices, but I'd like a pop up to trigger only if the selection made is either - special project or meeting. I want the pop up to say - please enter a comment by right clicking on this cell. I have this written so far, but I can't seem to figure out how to tell it all columns or my range of columns rather than just column B. I also am not sure how to add the second target value. Any assistance would be greatly appreciated. Thank you!


Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns("B")) Is Nothing Then If Target.Value = "Special Project" Then MsgBox "needs comment right click cell", vbExclamation
End Sub

 

[dmt32]

Hi
try

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Me.Range("B5:AF25")) Is Nothing Then
        If Not IsError(Application.Match(Target.Value, Array("Special Project", "meeting"))) Then
            MsgBox "needs comment right click cell", vbExclamation, "Comment Required"
        End If
    End If
End Sub

Dave

 

[synthesis45]

Thank you so much for your time. I really appreciate it!!!