Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
movermike
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Items, when selected doesn't appear!? Pivot Table Question? Items Excel Discussion (Misc queries) 1 October 28th 05 09:31 PM
is it possible to re-size or format list items in dropdown box? jc Excel Discussion (Misc queries) 1 August 14th 05 12:01 AM
Prevent new pivot table items from being selected Tom Excel Discussion (Misc queries) 3 August 10th 05 05:49 PM
How do I change the highlight color of selected menu items? PepperVL Excel Discussion (Misc queries) 1 March 12th 05 02:13 PM
Is it possible to copy only selected items to another worksheet... HEATHERCOX Excel Worksheet Functions 2 March 1st 05 01:21 PM


All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"