Excel reset button

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi all ,

I am using a form, inputting lots of data into many cells to get a quote, I wonder if there is a way of having a master reset button that resets all cells back to blank figures and clears all tyed cells of words.

Any help much appreciated.


Regards

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
If you want to do it manually, then select the cells that you want to clear and right click and choose ClearContent

You can do same via macro

Range("A2:Z100").clear
Can i attach this to a button that I click to reset all fields then at all please?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Yes, you can attach a macro to the button.
I suppose its too cheeky to ask how, sorry novice to Macro and button creation.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.