title: VBA - Excel Formula Caclulation
body: <p>I want to write a code in vba were produce a simple calculation, activesheet.cells(i,3) = activesheet.cells(i,2) * activesheet.cells(i,1)</p>
  
  <p>My question here is when i run once the code and then change the values on cells(i,2) and cells(i,1), i want the the cells(i,3)cell to automatically calculate the new value</p>
  
  <p>For example if cells(i,2) = 3 and cells(i,1) = 2 then cells(i,3) = 6
  I want to change the manually the values in excel to cells(i,2) = 4, cells(i,1) = 4, without running again the code I want automatically the cells(i,3) = 16</p>
  
  <p>This code be in a for loop</p>