Cell equals formula OR manual input

Hello

The subject says it all really!

At the moment, I have many cells which equal a formula, so the cells calculate based on the value of 2 other cells - simple.

The user also has the option to input figures via a UserForm, if they decide to use this, when they hit submit the formula will be overwritten with whatever value they typed into the UserForm - simple.

I'm just wondering if there's a way I can get the formula back if the user wants to use the formula version after already hitting submit on the UserForm without using a macro where it will copy the formula from another sheet and put it into the cell which originally contained the formula.


I hope this makes sense, thank you

cant be done withot Macro

That's annoying, thanks though.