+ Reply to Thread
Results 1 to 2 of 2

need some help with a counter for check boxes

  1. #1
    Registered User
    Join Date
    04-09-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    need some help with a counter for check boxes

    Hi guys, first time posting so be kind I tried to do a search but came up empty on my specific issue, I'll try to describe it as best as I can.

    For work, I created a spreadsheet that has 3 groups of approximately 7 items that can be check marked. I also added a "clear" button that removes all check boxes so we can start from scratch after each round. My issue is, I need to create 3 separate counters so that even after I hit "clear" the counter keeps going up whenever a specific group is used, and then a separate "clear" button for the counter itself (or some other means of resetting the counters to zero).

    example:

    1a
    1b
    1c
    1d

    2a
    2b
    2c
    2d

    3a
    3b
    3c
    3d

    Round 1:
    If I check mark one or more items from group 1, the counter for it should go up by 1 (regardless of how many items are marked).
    end result on the counter would be group 1 = 1, group 2 = 0, group 3 = 0

    Round 2:
    I check mark one or more from group 1, and check mark 1 or more from group 3 (regardless of how many items are marked)
    end result on the counter would be group 1 = 2, group 2 = 0, group 3 = 1 (adding in the info from round 1)

    at the end of the work day, I need a way for the counters to reset so on the next business day we start from scratch.

    What kind of script would help me accomplish this?

    EDIT: If it helps to have the script that I've created so far please let me know. I'll have to wait until tomorrow so I can give it to you exactly as is
    Last edited by RedZoneOS; 04-09-2014 at 03:41 AM.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: need some help with a counter for check boxes

    Please post a sample workbook along with the code you have already.

    As you surmise, you'll need separate reset buttons.
    David
    (*) Reputation points appreciated.

+ 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. [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
  2. Replies: 1
    Last Post: 05-23-2013, 10:42 AM
  3. Automatically check one or more check boxes when a parent check box is manually checked
    By Steverizer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2013, 01:56 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. 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

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