title: VBA code to display message based on cell value in a range of cells
body: <p>I am very new to VBA. I am trying to create a macro that will display a message based on cell value from a range of cells on a different sheet.I already have a macro that essentially is a ctlr + F and the goal is that when that ID number is entered this new macro will display a desired message.</p>
  
  <p>This is what I have and as you can tell I'm very new and probably isn't even close to what I need:</p>
  
  <pre><code>Sub Worksheet_Calculate()
      If Worksheets("worksheet").range("B2:B200") &gt; 0 Then
          MsgBox "message needed"
      Else
          MsgBox "other message needed"
          Exit Sub
      End If
  End Sub
  </code></pre>
  
  <p>In theory if there is a 0 in the cell that was searched from the range of cells in the first macro, then it will display a message, otherwise it will display an alternative message.</p>