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

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

On Wed, 9 Dec 2009 15:30:26 -0800, Charlie
wrote:

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