Macro cannot hide rows based on cell linked to checkbox

[fernaldd]

I cannot get my macro to hide rows based on the value of a cell linked to a check box. I got a macro to work when typing directly into a cell, but cannot get it to hide rows when a cell value is updated based on whether a check box is checked or not. So, if the check box is checked, the value in the linked cell becomes TRUE. Here's the code I used to hide a range of rows when typing the word TRUE directly in a cell:

Please Login or Register  to view this content.

Can this be modified to work with a cell value based on a formula? I'm a novice with VBA, so any help is appreciated.

Thanks.

[Macdave_19]

why don't you just apply the macro the the checkbox mate?

[fernaldd]

OK. Good idea.

I've assigned a macro to the Form control, but I get run-time error '424': Object required. Here's the code:

Please Login or Register  to view this content.

If I use an ActiveX Control it runs perfectly, but I prefer not to use the ActiveX control if at all possible. Any ideas why it doesn't like something about the Form control in the VB script?

Thanks.