clear button

[annick]

Hello,

I'm a bit new at this, so please bear with me. I'm trying to make a worksheet for my work and I've got everything just the way I want it, formulas and all. The only thing that I would like to add to it, is a "clear" button. So if you click on it, certain cells are deleted and the page returns to its original state. I've tried to construct a macro, but I'm rubbish with visual basic. Can anyone help me? Sorry if this comes across as being a really stupid question.
Thank you.
Warmest regards,
Annick

[Bryan Hessey]

Same answer as for many similar question. In Tools, Macro, Record New Macro, select and clear your area, select your required cell, then Stop Recording and Edit the macro. This should show the code required for your Button's code area.

hth
---

Hello,

I'm a bit new at this, so please bear with me. I'm trying to make a worksheet for my work and I've got everything just the way I want it, formulas and all. The only thing that I would like to add to it, is a "clear" button. So if you click on it, certain cells are deleted and the page returns to its original state. I've tried to construct a macro, but I'm rubbish with visual basic. Can anyone help me? Sorry if this comes across as being a really stupid question.
Thank you.
Warmest regards,
Annick

[annick]

Thank you,

I'll try that and see how it goes.

Warmest regards,
Annick