How To Apply A Button To Clear Specific Cells In Excel?

Need to work on the same workbook again and again? If so, you must be deleting specific cells to update your data. Then why don’t you create a button to clear specific cells in a workbook? This is what I am going to do today. A simple “Clear Cell” button for you.

This one is advanced excel tutorial and we are going to use Excel VBA for this project. Again, I am using Microsoft excel 2010 for the demonstration. Let’s get started.

Step 1: Create A button by Clicking “Insert” and Then “Shapes”.

Step 2: Add text on the button as button name. You can write “Clear” As button name

Step 3: Add Excel VBA by clicking “Developer” and “Visual Basic”.

Step 4: Now from the new window. Click “insert” and then click “Module”

Step 5: Write the code here (Please subscribe and here goes the code:   / 34608230  ) and click “Save”.

Step 6: You need to assign Macro to the button you created. Right click on the button and click “Assign Macro”

Step 7: Click on “Clear” and click “Ok”. (You need to select the button name here. Mine is “clear” so I clicked on that)

Done

This is how you create button to clear specific cells in excel. Hope you like it.

#excel10tutorial #clearbutton

Thanks for watching.


Support Us:   / excel10tutorial  


If you like this tutorial, please subscribe:
https://goo.gl/uL8fqQ

Checkout our Advance Excel Tutorial Playlist:
https://goo.gl/ExYy7v

Checkout the Excel tutorial for dummies playlist: https://goo.gl/UDrDcA

Checkout the Excel Case playlist:
https://goo.gl/xiP3tv

If you need any specific tutorial you can request that here: https://goo.gl/jM78fA

Connect us on social media

Facebook: https://goo.gl/hdJ7rN

Google Plus: https://goo.gl/Yk4DQc