Pop up message macro for wide column range.

Closed
angel - Mar 18, 2015 at 02:24 PM
Hello,
I need to figure out why my macro isn't working on a range of cells "M3:M54". I need a message to pop up if "Yes" is chosen from the cell. I am using the below macro in the VBA screen of Excel. it works fine if i use it for M3 alone or M4 alone but not when I enter in a range as M3:M54


Private Sub Worksheet_Change(ByVal Target As Excel.Range)

Dim rng As Range
Set rng = Range("M3")
If Not Intersect(Target, rng) Is Nothing Then
If rng = "Yes" Then
MsgBox "PLEASE FILL OUT ALL ASSORTMENTS ON THE BOM-ASSORTMENT TAB"
End If
End If

Set rng = Nothing

End Sub