Unfortunately this code does not work. It is supposed to evaluate every embedded boject on the worksheet. When the code comes across an ActiveX CheckBox, it should determine whether the CheckBox is checked. At the end of the procedure, a MsgBox will appear, confirming how many (if any) CheckBox were checked and their caption.
![Excel for mac 2011 how do i insert a checkbox file Excel for mac 2011 how do i insert a checkbox file](/uploads/1/2/5/4/125408436/828265080.jpg)
Buddy, Generally since you are posting a new question you should start a new thread. You can always paste the link to this thread in your new post to indicate what you have already reviewed. In addition it is a good idea to show what you have done so we see: 1) what you arrangement and presentation is 2) the formulas you are trying to use.
![Checkbox Checkbox](/uploads/1/2/5/4/125408436/694047008.png)
In your case countif will not work. You want to use the function sumif like: row 10 is a footer row which can make by selecting the number of footer rows you want in the table inspector: C10=SUMIF(B, TRUE, C). Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.