how to make the "select all"function

[Eric Tsang]

Dear all

I have need to make around 60 check box in a sheet

Around 8 of the in a group /section

can i make one "master"check box" once it is checked, the rest will be checked. If it is unchecked, the check box will be reset.

Thanks for your unanswer

Eric

[salim ali]

make the name of master check box as "Main_CH" and run this macro

Please Login or Register  to view this content.

[Eric Tsang]

Dear Samli

Thanks a lot of your help

I have watched a Youtube and get inspired
https://www.youtube.com/watch?v=WHrlR-fCVzE&t=114s

Please find my solution

As in the real case, i do have many tabs .
I just copy Store 1 to Store 2 , is that true that they are all independent?!

Because i got around 10 tabs... it that is true it saves my life

Or there is a better way.

Eric

[popipipo]

Please Login or Register  to view this content.

Or use this doubleclick function

[Eric Tsang]

Dear All

I found another way to save time with a "fake"Check box

However, would any guru can help me out
What would be the code if the Master checkbox is click then the following column will change to either char 254 or 268


Possible to use if function to change all the char(254) to char (168) according to the Master check box charater?

see the attached

Eric

[popipipo]

Please Login or Register  to view this content.

Use this macro