Return cell formula when checkbox = false

[revcall]

I am creating a form which allows the user to select items a-la-carte or as a predefined package. One of my cells needs to revert back to a formula when the package is deselected. Here is what I have:

Please Login or Register  to view this content.

At issue is the underlined part. How do I enter a formula that fills a cell based on the input of another?

**EDIT**
I think I need to clarify what I'm attempting to accomplish. I have the following code assigned to an activeX checkbox:

Please Login or Register  to view this content.

I then multiple the result of D22 by 690 and insert it in E22 (the simple formula of =D22*690 is placed in E22). When I run the code in the original post (triggered by an activeX checkbox), it wipes out the formula. I need to revert back to the above formula upon un-checking. Adding the suggested statement displays D22*690 but doesn't act like a formula. 'Show formulas' is not selected. I hope this helps.

Thank you!

[Fluff13]

Hi & welcome to the board
How about

Please Login or Register  to view this content.

Also please edit your post to add code tags, the # icon in the reply/edit window

[revcall]

Thank you for your response! Unfortunately, that places the formula in the cell whereas I need the formula to function, not be displayed.

[Fluff13]

Please edit your post to include code tags around your code.

That code does insert the formula into the cell, check that the cell is not formatted as text & that you do not have "Show Formulas" selected.

[revcall]

I stand corrected! That DID work! I was short one "=" in the code.

Thank you for your help!!

[Fluff13]

Glad it's sorted & thanks for the feedback
and thanks for adding the code tags.