title: Excel - Multiply contents of cell by 12, only once
body: <p>I am trying to update values entered into cells in <code>Column A</code>. I have the following script which works as expected, almost. It updates the cell, but then continues to update until it reaches an exponentially large number.</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Target.Column = 1 Then
          intcolumn = Target.Column
          introw = Target.Row
          Cells(introw, intcolumn) = Cells(introw, intcolumn) * "12"
      End If
  End Sub
  </code></pre>
  
  <p>Is there a way to make it so that I can make it so I can enter any number in A? and have it only multiply by 12 once? (1 = 12, 2 = 24, 3 = 36, 4 = 48, etc.)</p>