"If statement" launching MsgBox

Appreciate if anyone can suggest how to use an If statement formula where the true condition would launch a MsgBox macro. (Its for an excel sheet linked to live stock quotes, and I want to have an alert for when the price in the linked cell reaches a certain level)

You can adapt this to what you need, this will cause the message box to pop up when the value £1.50 is entered in cell A1 or if by suming the value of A1 reaches £1.50. Paste this code in to the code page for the worksheet you want it to work on.

Hope this is what you wanted as you were a little sketchy!

Simon

Public Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A1").Text <> "£1.50" Then
ElseIf Range("A1").Text = "£1.50" Then
MsgBox "Price is matched at" & Range("A1").Text
End If
End Sub