I have Item A and Item B in a dropdown and want a warning to pop up if Item B is selected.
M movermike Nov 23, 2005 #1 I have Item A and Item B in a dropdown and want a warning to pop up if Item B is selected.
L L. Howard Kittle Nov 24, 2005 #2 Hi Mover, Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$A$1" Then Exit Sub If Target.Value = "b" Then MsgBox "You picked B" End If End Sub HTH Regards, Howard
Hi Mover, Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$A$1" Then Exit Sub If Target.Value = "b" Then MsgBox "You picked B" End If End Sub HTH Regards, Howard
