How to run a calculation in a sheet using button in excel
<p>I am trying to create an form control or activex command button to change a series of values to a particular calculation.</p>

<p>My button is on a sheet named "Sheet 2" and the calculation needs to happen on a sheet named "Whatif back".</p>

<p>When i press the button, C2 in "Whatif back" must be calculated with C27 in "Sheet 2".</p>

<p>My code is:</p>

<pre><code>Sub Sheet2_Button18_Click()
Sheets("Whatif back").Range("C2")=(10000+Sheets("Sheet2").Range(C27))
End Sub
</code></pre>

<p>I am getting a compile error. Please help.</p>

<p>Thank you,
Shyam</p>