synthesis45
New Member
- Joined
- Jul 28, 2010
- Messages
- 4
I can't seem to figure out the exact need for my excel sheet. I have a sheet that has drop down menus in B5:AF25. There are many choices, but I'd like a pop up to trigger only if the selection made is either - special project or meeting. I want the pop up to say - please enter a comment by right clicking on this cell. I have this written so far, but I can't seem to figure out how to tell it all columns or my range of columns rather than just column B. I also am not sure how to add the second target value. Any assistance would be greatly appreciated. Thank you!
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns("B")) Is Nothing Then If Target.Value = "Special Project" Then MsgBox "needs comment right click cell", vbExclamation
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns("B")) Is Nothing Then If Target.Value = "Special Project" Then MsgBox "needs comment right click cell", vbExclamation
End Sub