Clear button
 

I am looking for a Macro. I am trying to have a button on my spreadsheet that
when clicked will clear data in specific cells.

For instance, a button when clicked will clear data from cells A1, B77 and
S66.


By the way, I don't know how to make the button either.
--
bob

Clear button
 

there are two methods. One where you put the button on the worksheet and the
second where you put the button on the top of the worksheet in a tool bar.

Here is how to put the button on the worksheet
1) Excel Menu View - toolbats - Control toolbox
2) Press the rectangular button on the toolbar. Then press on the worksheet
where you want the button to be located. You can resize the button. right
click the button and change CAPTION which is the words that appear on the
button
3) Double click on button and a macro window will appear with two lines of
code. change this code to look like the following. Don't change the button
number. each button on the worksheet will have aq unique button number which
is the name of the button that appears in the property of the button. If you
change the name property of the button then the macro name has to be the same.

Private Sub CommandButton1_Click()

Range("A1").ClearContents
Range("B77").ClearContents
Range("S66").ClearContents

End Sub


"vdmbqb" wrote:

I am looking for a Macro. I am trying to have a button on my spreadsheet that
when clicked will clear data in specific cells.

For instance, a button when clicked will clear data from cells A1, B77 and
S66.


By the way, I don't know how to make the button either.
--
bob

Clear button
 

Or a bit neater,

Range("A1,B77,S66").ClearContents

:-)

Clear button
 

Joel,

Thank you-this works perfectly.
Just one question, is there a way to write the same code in a range. For
instance; clear cells A1 thru A209.

Thanks again
--
bob


"Joel" wrote:

there are two methods. One where you put the button on the worksheet and the
second where you put the button on the top of the worksheet in a tool bar.

Here is how to put the button on the worksheet
1) Excel Menu View - toolbats - Control toolbox
2) Press the rectangular button on the toolbar. Then press on the worksheet
where you want the button to be located. You can resize the button. right
click the button and change CAPTION which is the words that appear on the
button
3) Double click on button and a macro window will appear with two lines of
code. change this code to look like the following. Don't change the button
number. each button on the worksheet will have aq unique button number which
is the name of the button that appears in the property of the button. If you
change the name property of the button then the macro name has to be the same.

Private Sub CommandButton1_Click()

Range("A1").ClearContents
Range("B77").ClearContents
Range("S66").ClearContents

End Sub


"vdmbqb" wrote:

I am looking for a Macro. I am trying to have a button on my spreadsheet that
when clicked will clear data in specific cells.

For instance, a button when clicked will clear data from cells A1, B77 and
S66.


By the way, I don't know how to make the button either.
--
bob

Clear button
 

Range("A1:A209").ClearContents

Or incorporated with your earlier ones:

Range("A1:A209,B77,S66").ClearContents

Clear button
 

Thank you-you guys are great!!
--
bob


"dimm" wrote:


Range("A1:A209").ClearContents

Or incorporated with your earlier ones:

Range("A1:A209,B77,S66").ClearContents