+ Reply to Thread
Results 1 to 3 of 3

Count or tally non checked content control boxes

  1. #1
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Boston
    MS-Off Ver
    MS 365
    Posts
    225

    Count or tally non checked content control boxes

    I have a 10 page check list of chores (50 chores in all.)

    When the user completes a chore the associated box (content control box?) is clicked then an “X” appears in the box indicating chore is complete.


    I would like to have a counter or some sort of tracking of the progress at the end of the list (page 10) to show remaining chores. Ideally have a notice appear when all chores are checked off.

    I'm very limited on VB but willing to work at it and do research.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Count or tally non checked content control boxes

    If you use formfield checkboxes in a document with forms protection, you could use a macro like.
    Please Login or Register  to view this content.
    The code assumes your final formfield in the document will be a text formfield where the results can be output.

    If you use content controls, you could use a ContentControlOnExit macro like:
    Please Login or Register  to view this content.
    Again, the code assumes your final content control in the document will be a text content control where the results can be output.

    There are advantages & disadvantages to each approach:
    • formfields work on Macs, but content controls don't.
    • formfields need to be tabbed out of to update, but content controls can use tabs or mouse selections.
    • formfields require the macro to be attached to each checkbox's 'on exit' property, but content controls don't.
    • formfields require 'filling in forms' document protection to work, but content controls don't. With 'filling in forms' document protection, only content in formfields & content controls is accessible for editing.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Boston
    MS-Off Ver
    MS 365
    Posts
    225

    Re: Count or tally non checked content control boxes

    Thanks for the ideas Paul - this will take some review to figure out how to use it. This is something I'm very interesting in figuring out.

    Regards,-

    jt

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Count checked fieldform and content control boxes from word using excel
    By morganhughes360 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2015, 06:39 AM
  2. Need to Count number of Check Boxes checked on a userform
    By UMBiii in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2014, 03:44 PM
  3. [SOLVED] How to Count Check Boxes and count the total number of boxes checked
    By t04904 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2013, 11:45 AM
  4. Count number of checked boxes
    By Motox502 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-02-2012, 03:11 PM
  5. How do I tally checked check boxes in an Excel spreadsheet?
    By acpharmd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2006, 04:40 PM
  6. In Excel, how to count a list of check boxes some are checked?
    By M. Zak in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-26-2006, 05:55 PM
  7. I want to be able to count the number of checked boxes in a form?
    By cldavis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2005, 05:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1