Hi,

When you say "form check box" do you mean a checkbox on a UserForm in the
VBE or do you mean you have created a sheet which you are using as a form?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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