check box

[Don Juan]

I made two macros. One that inserts an altered formula into a cell and one that puts that altered formula back to normal. Im trying to paste that into the checkbox code but its not reading the "put it back to normal" code, mainly becuase I think I have to insert code that identifies what to do if the checkbox is unchecked. How do I code to make the program acknowledge when the checkbox is unchecked so I can put that "put it back to normal" code after it.

check box checked = altered cell
check box unchecked = back to normal

[Paul]

Something like this should work, change your cell/range as needed:

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