Thanks for the response...

How do I assign the macros? When I right click it doesn't give me the
option.

"L. Howard Kittle" wrote:

Hi Jeff,

Pretty straignt forward.

Sub ClearIt()
Range("A3:A7,A10,D3:D7,G3:G7").ClearContents
End Sub

Copy and paste in the sheet module(View Code) and then make your button from
the forms tool bar and assign the macro to the button.

HTH
Regards,
Howard

"jbf frylock" wrote in message
...
I've read some of the other on here and can't get it to work.

I have cells A3:A7,A10,D3:D7,G3:G7

I want the values in these cells to be deleted when I click a Clear All
button.

So, do I create the button, go to view code and enter it there. I
specifically need help with the code.

Any help would be great...thanks,

Jeff