uncheck a checkbox with a macro
 

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!

uncheck a checkbox with a macro
 

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

Jim Thomlinson


"GeoffWhite18" wrote:

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!

uncheck a checkbox with a macro
 

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

regards
FSt1
"GeoffWhite18" wrote:

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!