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

Reset button excel
Battery reset code - Guide
How to reset ps4 controller without reset button - Guide
At button - Guide
Samsung button phone reset code - Guide
Nokia factory reset code forgot - Guide

1 response

Answer 1 / 1

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

Andy
May 10, 2010 at 05:27 AM

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.

Andy
May 10, 2010 at 05:34 AM

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.

Similar discussions

lava hard reset & factory reset

Similar discussions

Subscribe To Our Newsletter!