On Jun 4, 4:33*pm, FSt1 wrote:
hi
you can do it with a forms check box IF the check box is on a form. if not
and the check box is on the sheet then use the control check box.

Regards
FSt1



"dicko1" wrote:
Trying to assign a macro to a check box that will hide and unhide rows
depending on whether its checked or not. I can do it using a control
check box, but not a form check box. Any ideas?

Here is the code that works for the control check box:

Private Sub CheckBox1_Change()
* *If CheckBox1.Value = False Then
* * * Issue_Mgt_Hide ( 'I assigned it to a different macro called
Issue_mgt_hide)
* *Else
* * * Issue_Mgt_Unhide
* *End If
End Sub

Thanks for any help!

Ryan- Hide quoted text -

- Show quoted text -

When I say a form check box, I mean one created from the Form's
Toolbar, not the Control Toolbox. This is created on a sheet.

I'm thinking something like this.....

Sub CheckBox()


If Sheet1.CheckBoxes("Check Box 1").Value = 1 Then
Issue_Mgt_Hide
Else
Issue_Mgt_Unhide
End If


End Sub

Thanks,