| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check and uncheck macro | Excel Worksheet Functions | |||
| check and uncheck macro | Excel Discussion (Misc queries) | |||
| How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
| check/uncheck a checkbox | Excel Programming | |||
| Check and uncheck a checkbox | Excel Programming | |||
Hybrid Mode
