Message Box to linked Cell

[DSL1970]

Hey Folks,

I am trying to get a pop-up box to appear when a linked cell goes below a certain value....

On the code below cell "S15" is linked to my "Sheet1, cell C5", but when the value of C5 goes below 10, it should display a pop-up, but doesn't. Can anyone help me with the additional code to get this to happen?


Private Sub Worksheet_Change(ByVal Target As Range)

If Range("S15").Value < Range(10).Value Then
MsgBox "No data shown for less than 10"
End If


End Sub

Thanks.

 

[Coding4Fun]

Private Sub Worksheet_Change(ByVal Target As Range)


If Range("S15").Value < 10 Then
MsgBox "No data shown for less than 10"
End If


End Sub