Adding a "CLEAR" button to the worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my worksheet I would like to add a"CLEAR" button that would delete the
contents of multiple cells.
 
Go to View/Toolbars/Control Toolbox/Click on the command button icon and
place on the sheet.

Right click the button and place this code into it (Change the cell
reference to the cells you want to affect). Then change the range to
suit.


Code:
--------------------

Sheets("sheet1").Activate
Range("a2,d2,f2,h2").Select
Selection.ClearContents

--------------------


Come out of design view and test. Make sure to test this on a copy.

Larry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear Cell Fill when leaving Worksheet 2
How to clear up useless content within worksheet? 1
Clear Contents 1
Create a yes no message on a command button on click 0
clearing a drop down menu entry 2
When sharing, can I force an Excel document to open in a certain view? 0
Creating a list of info in A1 cell in multiple worksheets 4
How to use multiple command button to copy user form data to multiple worksheet 0

Back
Top