VBA to override formula in cell

[MariahLeach]

Hi All,

Looking for some help in VBA.

I want to be able to tick a box, and when ticked I would like a new formula to override a cell. When unticked, would like to have the original formula in the cell calculate

The original cell formula calculates a new Value based off of a hardcoded percentage you manually input.

The original formula for H9 is: =IFERROR(IF(OR(G11>0%,G11=0),G11*C$4,""), "") - G is the percentage you manually input - C4 is the overall value of the account

If I tick the box I would like the formula for H9 to be: =IFERROR(SUM(D11/$C$4),"")

Any ideas on writing a code? I need to create this option individually for 100 cells

Thanks in advance!

 

[Micron]

There is no way to restore the edited value unless you store it somewhere. No idea if you intend that to be in code, which won't work unless the variable holding the formula remains in scope after the procedure runs, or if you'll store it somewhere else in the workbook. Might be easier if some cell in the row contained a trigger value and the formula just used IF(cell address = TriggerValue, then formula(1), else formula(2))? Do you really need the OR? Wouldn't IF >= 0 work?

 

[bebo021999]

What do you mean "tick a box"? Is it a "check box"? Does it come from "form controls" or "ActiveX Controls"?