stop calculation

[BrendanDixon]

Hi all,

I have a spreadsheet that calculates the difference in date and time from a predetemined date and time to the current date and time. I would like to have it that I have a form checkbox and when I check the checkbox it will keep the value in the calcutation but is will not continue calculating on the cell. I do not want to change to manual calculations because the are other calculations running on the same spreadsheed.

Example of what I have( but not doing what I want it to):
I have the check box linked to cell A4
Cell A3 =A1-(A2*A)

When the check box is selected it gives the answer I want when it is unchecked and when unchecked it gives the answer of A1

can somone help

 

[tweedle]

I couldn't do this with formulas alone; had to put code in to make this scenario work.

Private Sub CheckBox1_Click()
    If CheckBox1.Value Then
        Range("A3").Formula = "=A1-(A2*A1)"
    Else
        Range("A3").Value = Range("A3").Value
    End If
End Sub

 

[BrendanDixon]

mmmmm no does not seem to work


Basically what I want to do is prevent the automatic calculation of cell A3 if the checkbox is checked. I tried you code and it seems to still update when I refresh the sheet.

 

[tweedle]

You can switch it up then...

Private Sub CheckBox1_Click()
    If [COLOR=blue]Not[/COLOR] CheckBox1.Value Then
        Range("A3").Formula = "=A1-(A2*A1)"
    Else
        Range("A3").Value = Range("A3").Value
    End If
End Sub

(Also, the formula being coded to A3 is sample)