Thank you so much. Amazing how quickly it works when done correctly.

"L. Howard Kittle" wrote:

Thanks, but when I right click it doesn't give me the option to assign
macros.

Use a button from the Forms toolbar.

View ToolBars check Forms

Now make your button from that tool bar using the button icon.

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