Macro Form Control Updating Values

[SeanDerrick]

I have recorded the following macro and assigned it to a form control to display the value of a calculated cell. It works fine but when I change the calculation, it changes the value of the target cell. I want to keep the value static until I click "update". Any suggestions? Thanks.

Sub Update1_Click()
'
' Update1_Click Macro
' Present Situation Update
'
'
Range("L24").Select
ActiveCell.FormulaR1C1 = "=VALUE"(R[2]C[-10])"
Range("L24").Select
End Sub

 

[GlennUK]

The logic would be something like:

Range("L24").FormulaR1C1 = whatever
Range("L24").Value = Range("L24").Value

 

[GlennUK]

...