How To Create a Button to Clear Cell Value but Keep the Formula

How To Create a Button to Clear Cell Value but Keep the Formula
Suppose you are using a data format in excel and you need to reset the data every time. Unless you want to do it manually it's better to create a clear button in Excel. I’ve showed this type of tutorial already here they are:

But this tutorial is different. What if your selected data has formulas in it. If you remove the value your formulas will also be removed. This is why I’ve created a vba code so that you can use it and clear cell content in Excel but keep the formula.

Let’s follow the instructions below to clear contents in excel without deleting formulas using vba.

Step 2: Click on Visual Basic
Step 3: Click "Insert" and then "Module"

Step 5: Close the VBE

Now we need to create button in excel. There are several tutorials on the channel to create buttons for VBA you can check them here:

Now that you’ve created a button, click on it. It will ask for the data range. After selecting the data range click ok. Done. Now excel will clear cells but keep the formula from your selected data range. This is how you clear contents in excel without deleting formula.

#ClearContent #KeepFormula #Button

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[larrytabizon]

What is the code? or the video that shows the code you used?

[yancyquerijero]

can u add the whole command of the developer

[JayTee]

You did not show the whole process, you just paste the process and that all.

[bobbyrama]

You're too quick when your showing what to click on.