button to update cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to assign an option button to perform a calculation on the contents of a cell say C12. Then replace the contents of the Cell with the product of the equation. It seems like it should be as easy as assigning a variable1 to = C12, perform calculation on variable ((variable1*D12)+E12), populate C12 with variable2. But, I can’t seem to get the code right
Any Help would be appreciated
 
Jerrett,

Is it not as simple as?

Range("C12").Value = (Range("C12").Value * _
Range("D12").Value ) + _
Range("E12").Value

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Jerett said:
I am trying to assign an option button to perform a calculation on the
Click to expand...
contents of a cell say C12. Then replace the contents of the Cell with the
product of the equation. It seems like it should be as easy as assigning a
variable1 to = C12, perform calculation on variable ((variable1*D12)+E12),
populate C12 with variable2. But, I can't seem to get the code right.
 
Back
Top