Have 2 items in dropdown, want warning if one selected
I have Item A and Item B in a dropdown and want a warning to pop up if Item B
is selected. |
Have 2 items in dropdown, want warning if one selected
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 "movermike" wrote in message ... I have Item A and Item B in a dropdown and want a warning to pop up if Item B is selected. |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com