Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear check box problem
I have added check boxes to an Excel 2003 spread sheet. I used the Forms
Toolbar. There is an existing Clear button that clears selected cells. I want to modify the Clear button macro so that the check boxes are cleared also. I tried to use the code from a previous post (Kyla 4/26), but it didn't work. Below is the code for the Clear button: Private Sub Button1_Click() Range("L9,J12,F14,F15,F16,L19").Select Selection.ClearContents Range("l9").Select End Sub I am a novice and know next to nothing about macros. The Clear button is my first macro which I got from a post. -- dow |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear check box problem
Dim cb As CheckBox
For Each cb In ActiveSheet.CheckBoxes cb.Value = False Next cb -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "dow" wrote in message ... I have added check boxes to an Excel 2003 spread sheet. I used the Forms Toolbar. There is an existing Clear button that clears selected cells. I want to modify the Clear button macro so that the check boxes are cleared also. I tried to use the code from a previous post (Kyla 4/26), but it didn't work. Below is the code for the Clear button: Private Sub Button1_Click() Range("L9,J12,F14,F15,F16,L19").Select Selection.ClearContents Range("l9").Select End Sub I am a novice and know next to nothing about macros. The Clear button is my first macro which I got from a post. -- dow |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear check box macro | Excel Programming | |||
excel check register template. How to put symbol in clear column | Excel Discussion (Misc queries) | |||
Clear All Check Boxes | Excel Programming | |||
Using a Macro to clear out check box seletions | Excel Worksheet Functions | |||
how clear up this problem | Excel Programming |