Everytime the values 1002, 1004, and 1005 are inputted in column A, I want the message to pop up "Reminder to indicate color". Below is the code that I have right now in the worksheet. As you can see this works when the value 1002 is inputted but when I tried to make it - If Cell.Value = "1002" Or "1004", the code doesn't work. The message pops up regardless of what the change is. How can I make the message pop up only on the values that I want? Thank you in advance!
Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim Cell As Range If Not Intersect(Target, Columns("A")) Is Nothing Then For Each Cell In Intersect(Target, Columns("A")) If Cell.Value = "1002" Then MsgBox "Remember to indicate fur label color - red or blue." Next End If End Sub