MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Deleting Cells with a button


Posted by Paul B on January 18, 2002 3:25 PM

How do I delete, or return cells to 0 by pressing a button. What is the function called?


Posted by Paul B on January 18, 2002 4:00 PM

Re: Oops... I mean, how do I clear cells with a button

How do I clear cells with a button. I want the button to clear cells on multiple documents.

Posted by B.H. Davis on January 20, 2002 4:47 PM

Paul,

I just set his up myself last week. In Excel97 I simply "recorded" a macro selecting all the cells I wanted to "clear". With the automatic recording feature it was a breeze. Then I created a button with the FORMS toolbar and assigned the macro to that button.

I hope this is what you are looking for.

BH Davis