title: How can I sum value in 8 textboxes to the a single textbox?
body: <p>I can't find a way to do this. I think it's a very basic question, but i'm just new with excel VBA and can't find the right formula. </p>
  
  <p>Recently i understand that to do the sum, i have to change each of the <strong><code>textboxes</code></strong> into integer first, then i can add it to a single <strong><code>textbox</code></strong>, so i'm converting each value into integer while i sum them one by one to a text box.</p>
  
  <p>I have tried this code.</p>
  
  <pre><code>Private Sub txtTotal_Change() 
  txtTotal.Value = CInt(txtKas) + CInt(txtInvestasi) + CInt(txtDanaTerbatas) + CInt(txtBruto) + ...
  End Sub
  </code></pre>
  
  <p>How can i sum this multiple textboxes (8 textboxes) into a single textbox? </p>