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

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" <(E-Mail Removed)> wrote in message
news:0B89EC93-15FB-4A3E-BE05-(E-Mail Removed)...
>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