Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Items, when selected doesn't appear!? | Excel Discussion (Misc queries) | |||
is it possible to re-size or format list items in dropdown box? | Excel Discussion (Misc queries) | |||
Prevent new pivot table items from being selected | Excel Discussion (Misc queries) | |||
How do I change the highlight color of selected menu items? | Excel Discussion (Misc queries) | |||
Is it possible to copy only selected items to another worksheet... | Excel Worksheet Functions |