Dear bosses, I a small white, just contact with VBA, question for help, thank you! EXCEL2013
In the page about 50 check box, want to do two buttons, realize the following functions:
1, hidden, when the check box has a select box, such as chose 25, then click on the hide buttons will left 25 didn't hide box,
2, display, when hidden want to modify the other check box after all check box to display,

Of course, if can not check the check box in the line of the hidden, by the way is better,

CodePudding user response:

Be clear
Check box is a form control or ActiveX control
If the ActiveX control, you are in the form or on the work table

CodePudding user response:

EXCEL with data filtering, why want to use VBA

CodePudding user response:

Code is "according to the object" for a visit, and whether the object hidden it doesn't matter,
Only when the "users" hidden object could not be accessed,

So-called "hidden", essence is the line height is 0,
But you have work the control object, inserted in the table is not necessarily "belongs to the cell,"
If the some row height change, may cause the control line with the corresponding "dislocation", this "hidden" need to be careful,

CodePudding user response:

Add a column, tick and tick, then increase the filtering of the column, do you want to filter choice is not tick off line