using button to clear contents

  • Thread starter Thread starter Charlie
  • Start date Start date
C

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
 
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
 
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
 
Back
Top