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
|