Frncis
Member
I am trying to have a msg box pop up when "Yes" is entered in range "G4:G10,G13:G17". However the code is not working, even when I list the range as one cell.
I did Debug ( no error), test ran the code & no response. Please let me know wat I am doing wrong.
Code:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Worksheets("October_Meeting_#_1").Range("G4:G10, G13:G17").Value = "Yes" Then
MsgBox ("Please Enter the SC or NSC status, if this is the first meeting of the new Fiscal!")
End If
End Sub