hi guys,
i had a problem on tick box.i wanna to tick all check box in just one click,how to do these thing?then it can count up the tick box in colum s20 in sheet 1.please help.
spbtg3.xlsm
hi guys,
i had a problem on tick box.i wanna to tick all check box in just one click,how to do these thing?then it can count up the tick box in colum s20 in sheet 1.please help.
spbtg3.xlsm
Hi pejoi
This Code will tick all your CheckBoxes and count them...I'm not certain what you mean by thisAssign the Code to CheckBox 287 (Select All)can count up the tick box in colum s20 in sheet 1Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
dear jaslake, you're had solved 50% of my problem and i'm sorry for the unclear question.actually,i need to count up the total of books given for each person in colum s20:s37 according the selected check box.please help.
hello,any help?
Hi pejoi
I can think of two ways to do as you require:
You're using Forms Control CheckBoxes and they are not numbered sequentially across each row (first several rows are) which creates a Code issue.
If you were using ActiveX CheckBoxes we'd have more functionality to work with.
It'll take me a bit to work through this.
Hi pejoi
This Code in in the attached...try it...let me know of issues.Please Login or Register to view this content.
wow!!it's solved.thanks jaslake!
You're welcome...glad I could help. Thanks for the Rep.
you are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks