Excel reset button

Closed
Andy - May 10, 2010 at 04:38 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 10, 2010 at 08:01 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 10, 2010 at 05:12 AM
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
0
Can i attach this to a button that I click to reset all fields then at all please?
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 10, 2010 at 05:29 AM
Yes, you can attach a macro to the button.
0
I suppose its too cheeky to ask how, sorry novice to Macro and button creation.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 10, 2010 at 08:01 AM
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.
0