Check Boxes

[rizmomin]

Hello:

Please refer to attached file.
I have check boxes in cell I1:I14
I need a Code which will toggle Check/uncheck all check boxes if check box in cell I17 is clicked.

Let me know if you have any questions.
Thanks.

Riz

[JieJenn]

Assign this macro to your check box 37

Please Login or Register  to view this content.

[MickG]

Try this:-

Please Login or Register  to view this content.

[rizmomin]

Hi JieJenn:

I have not done check boxes in the past as much.
i am having problem assigning/creating check box and name as "Check Box 37"
Please guide little further.
Thanks a lot
Riz

[JieJenn]

I thought the CheckBox in Cell I17 is named Check Box 37

[rizmomin]

Hi MickG:

Got it, thanks a lot.
Will test more and let you know if further help is needed.
Thanks.
Riz




Riz

[rizmomin]

Hi JieJeen:

Thanks a lot.
Will test more and let you know if further help is needed.
Thanks.
Riz