title: Excel Message box when cell value more than 100
body: <p>I have a report that have 2 rows, the first one is " Item " and the second is " Weight ".</p>
  
  <p>the " Weight " will calculated and if the total summary is more than 100 % then Excel will show Warning Box.</p>
  
  <p><a href="https://i.stack.imgur.com/plBwT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/plBwT.png" alt="The form"></a></p>
  
  <p>Can you guys help me to find a way to make it in Excel?</p>
  
  <p>this is script I use before:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      Set Target = Me.Range("A2:B10")
      If Target.Value &gt; 100 Then
          MsgBox "You exceeded 100"
      End If
  End Sub
  </code></pre>