Pop-up message for certain options in a drop-down menu

[highlandhouse]

Hi,

I'm wondering if there's a way to have a pop-up message if certain options are selected from a drop-down menu. I'm using Excel 2010 to create a form for information regarding medications. I've used Data Validation to create drop-down menus of all the possible medications that the form could be used for, but certain medications require an additional form, so I want a pop-up message if any of those meds are selected to remind the user that they must also include the additional form. I work in human services, and while I'm fairly computer savvy (and quite good at following directions!), I am far from being an IT person or a programmer, so please bear with me if this requires more explaining than usual!

Thanks for your help!
Kim

 

[TheJay]

For anyone looking at this since forum conversion, this is how it should appear:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "G1" Then
    Select Case Target
        Case "Med 1", "Med 5", "Med 8", "Med 10": MsgBox "Please Use Special form with this selection"
    End Select
End If
End Sub