Excel reset button

Closed
Andy - May 10, 2010 at 04:38 AM
rizvisa1 Posts 4478 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 response

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