using button to clear contents

[Charlie]

I have finally found out how to add a button but now I am haveing a problem
on having the button clear contents in certain cells does anyone know how to
do this
thanks for your help I do not know any codes for this

 

[Gord Dibben]

I'll bet you could learn very quickly by using the macro recorder while you
select some cells and edit>clear>contents.

Here is a sample for a button from the Control Toolbox

Private Sub CommandButton1_Click()
ActiveSheet.Range("certain cells").ClearContents
End Sub

"certain cells" would be your range of cells.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Just to add to Gord's response.

If you want to clear the contents of the current selection, you could modify the
code to look like:

Private Sub CommandButton1_Click()
Selection.ClearContents
End Sub