title: i keep on getting mismatch error in excel 2007 in VB
body: <p>Hope all is well with you.</p>
  
  <p>I want to ask help for my excel vb. I am not sure what else do i need to edit in my codes since the calculation works but the run time error mismatch type always pop up.</p>
  
  <pre><code>    Private Sub txtQty_Change()
   VAT.Value = txtQty.Value * 0.12
  End Sub
  </code></pre>
  
  <p>Any help would be highly appreciated. Thanks</p>