title: VBA Stop calculation of cells
body: <p>Very new to VBA in Excel, got asked to do some validation on cell change and got a bit stuck.</p>
  
  <p>So, user needs to enter a monetary value into a cell, let's say D16, so I thought I'd hook into the _Change event on the Worksheet which works quite well.</p>
  
  <p>However, I need the rest of the worksheet to not complete the calculation when an entry has been submitted into D16, basically, when 500000 is entered, other cells gets updated with values from another worksheet.</p>
  
  <p>My code</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
      If Target = Range("D16") Then
  
         Dim numeric
         numeric = IsNumeric(Target)
  
  
         If numeric = False Then
  
            MsgBox "error"
            Exit Sub
  
            /// this is where I need to "stop" the calculations from firing
  
         End If
  
      End If
  
  End Sub
  </code></pre>