+ Reply to Thread
Results 1 to 4 of 4

Counting check boxes in excel

  1. #1
    Registered User
    Join Date
    09-18-2017
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2016
    Posts
    2

    Counting check boxes in excel

    Hi,

    I want to calculate how many checkboxes are marked.
    How can I do this?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-16-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: Counting check boxes in excel

    Dear

    Each box is linked to specific cell
    at column W
    so
    activate this link
    by R. clicking on box
    it will open its properties
    add the cell name in column W
    at end if it is clicked value at W cell will be true or false is not clicked.
    count the trues
    it is the one you are looking for

    https://www.excelforum.com/attachmen...1&d=1505742498https://www.excelforum.com/attachmen...1&d=1505742498
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-18-2017
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2016
    Posts
    2

    Re: Counting check boxes in excel

    Thanks for your help.

    only it's not exactly clear to me.

    how do I automatically put in False/True.

    Also the total should be calculated in Row 46, Kolom M, O, Q, S, and U.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-16-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: Counting check boxes in excel

    Will fix it for you ��

+ 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. Check boxes that delete other check boxes and change the color of another cell.
    By nhamhamilton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2014, 02:40 PM
  2. [SOLVED] Coding Yes/No option buttons to not allow check boxes or require check boxes
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 11:32 PM
  3. Replies: 3
    Last Post: 08-27-2014, 10:13 PM
  4. I need a code for presence check to check multiple text boxes and combo boxes
    By Lee_wwfc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2013, 01:53 PM
  5. Excel VBA to generate check boxes and restrict user to tick on the 3 boxes in a row
    By rhodalynn.rona in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2012, 05:55 AM
  6. Automatic setting of check boxes based on other check boxes?
    By ArchiveMike in forum Excel General
    Replies: 5
    Last Post: 07-31-2012, 09:43 AM
  7. Counting check boxes
    By jesika in forum Access Tables & Databases
    Replies: 3
    Last Post: 03-21-2009, 12:15 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