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