kateebebe
asked on
Need Msgbox to only appear once when specific cell changes
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"
Case Else
End Select
End Sub
Private Sub Worksheet_SelectionChange(
Select Case Range("B5").Value
Case "CAB Rating - Dangerous"
MsgBox "Referral is Required for Cab Ratings of Dangerous"
Case Else
End Select
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER