View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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!