Need Msgbox to only appear once when specific cell changes
Posted on 2012-09-06
I have a validation box with a list in it and I just want a msg box to show when the user selects "CAB Rating - Dangerous" from the dropdown. All the If statements, and case ranges make the msgbox appear with every cell that is selected, not just when cell b5 changes. What am i missing?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Range("B5").Value
Case "CAB Rating - Dangerous"
MsgBox "Referral is Required for Cab Ratings of Dangerous"