Clearing certain cells

[anthony Slater]

I have a worksheet with 4 cells that take user-inputted
values. The rest of the worksheet is protected to avoid
potential deletion of formulas

Is there a macro (or something else) I can assign to a
form button that will automatically clear or zero the 4
cells when the button is clicked?

Any help or suggestions appreciated (as always)

 

[Frank Kabel]

Hi
try something like

sub foo()
range("A1").clearcontents
range("D2").clearcontents
....
end sub

 

[Anthony Slater]

Frank

Thanks mate...worked a treat

-----Original Message-----
Hi
try something like

sub foo()
range("A1").clearcontents
range("D2").clearcontents
....
end sub

--
Regards
Frank Kabel
Frankfurt, Germany



.