I've just watched the YouTube video about adding a message box via a macro to a data validation list and was after some additional help with it.
The code works perfectly for the one cell I have named in the range but I want to able to apply the macro to all of the cells within my worksheet that have data validation on them.
I've tried naming all of the cells in the range like this;
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Range ("C12, C13, C14, C17, C18, C19, C20")
Case "No"
MsgBox "Remember to add a reason!"
End Select
End Sub
That doesn't seem to work though and the message box only comes up on the other cells if the very first cell has 'No' selected.
Is it possible to apply the code to multiple cells? Any help or idea would be greatly appreciated.