Create a Reset Button

[thefinu]

Can anyone write the code for me?

I created the reset button. When you click the reset button, I want to have the form reset back to the formulas I have in there.

So for example, you can change cell E21, and cell E11. The click the reset button and they go back to the formula of D21/12 and D11/12 respectively. I want to do this for all the cells E6:E36.

Thank you in advance for all of your help!!

[mehmetcik]

I do not think that you need a reset button.

It is a lot simpler to delete what is in the cell and to have the formula reappear.


Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it.

Please Login or Register  to view this content.

[thefinu]

I think I need a reset button. I have many people that will be using this sheet, and aren't going to remember what cells they overrode with data. The reset will give them the option to have it go back to as before to work with the next subject.

Does that help?

Thank you for your response!

[mehmetcik]

You could use both.

Please Login or Register  to view this content.

[thefinu]

I thank you for being so patience. You are dealing with the simplest of the simplest...

I plugged it in (incorrectly of course) and got the following:

Attachment 653754

[mehmetcik]

I have attached a sample spreadsheet for you to look at.