I need help with a code to detect deletion of a cell's value.
In cell I10, a user can choose one of six items from a data validation list. Right now, I have code in there to pop up a
message if the user selects value "X" from cells F6:F10 and G6:G10, but cell I10 does not have value "A",
"B" or "C" already selected.
What I want, is if cells F6:F10 and G6:G10 have value "X" in them, and the user deletes values "A",
"B" or "C" from I10 or changes it in any way after it has been filled, then to have a message box pop
Here's the code I have:
If .Count > 1 Then Exit Sub
If Not Intersect(.Cells, Me.Range("F6:F10")) Is Nothing Then
If UCase(.Value) = "VALUE X" And Range("I10").Value = "" Then
MsgBox ("You didn't say the magic word!")
So that's what I have to prompt my user to make a selection from I10 (if desired - it's not a requirement). I just need to
know how to make a secondary message (i.e. "Are you sure you wanna do that?") come up if they remove choice
"A", "B" or "C" from I10.