title: How to pop up a message in Excel depending on the value of a cell range?
body: <p>I have variable values in the cells of column A starting with cell A1. I want to write a VB code to popup different message boxes if the value in the targeted cells become equal to 12, and equal to 13, and so. But less than 12 no need a massage box to popup. The cells in the column A has formula which is relevant to the cells in same sheet.   </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range) 
      If Intersect(Target, Range("A24:A300")) = 13 Then 
          MsgBox "add 1 into the existing Forfeited PH value?" 
      End If 
      If Intersect(Target, Range("A24:A300")) = 14 Then 
          MsgBox "add 2 into the existing Forfeited PH value?" 
      End If 
  End Sub
  </code></pre>