uncheck a checkbox with a macro

[GeoffWhite18]

I need a macro to delete information in cells (A2:G2), and change the value
of a check box to false. The check box is linked to cell (E2) and the value
should change to false. The check box was created useing the forms tool box.
Thanks!

 

[Jim Thomlinson]

Sub whatever
Range("A2:G2").ClearContents
end sub

 

[FSt1]

hi
just to add to jim's responce...
Sub whatever
Range("A2:G2").ClearContents
Range("E2").value ="False"
end sub

regards
FSt1