Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Count Ticked Check Boxes On Form

Discussion in 'Information Technology' started by Barry, Jul 28, 2006.

  1. Barry

    Expand Collapse

    I have a form which makes check boxes visible depending on a value selected
    by the user as a start and finish value. the check boxes are split into
    colums from A-C and in rows from 0-30. This works fine but what i now need to
    do is count all the check boxes ticked in column A and a count of all the
    check boxes ticked in column B etc..

    can anyone please help me with this??

    Here is the code i have used to make the check boxes visible

    Dim a As Integer
    Dim b As Integer
    Dim c As Integer
    Dim CheckA As String
    Dim CheckB As String
    Dim CheckC As String

    StartLevel = Me.txtStartLevel.Value
    FinishLevel = StartLevel + Me.txtNoOfLevels.Value - 1

    For a = StartLevel To FinishLevel
    CheckA = "chkLevela" & Format$(a)
    Me(CheckA).Enabled = False
    Me(CheckA).Visible = False
    Next a

    For b = StartLevel To FinishLevel
    CheckB = "chkLevelb" & Format$(b)
    Me(CheckB).Enabled = False
    Me(CheckB).Visible = False
    Next b

    For c = StartLevel To FinishLevel
    CheckC = "chkLevelc" & Format$(c)
    Me(CheckC).Enabled = False
    Me(CheckC).Visible = False
    Next c
  2. Loading...

    Similar Threads Forum Date
    What Counts As "sangat" To You? Interfaith Dialogues Mar 15, 2017
    Ashdoc's Movie Review---The Accountant Theatre, Movies & Cinema Oct 21, 2016
    Gurmat Vichaar | Futility Of Counting Paaths | April 12, 2016 Gurmat Vichaar Apr 23, 2016
    Wolf Count Blogs Oct 17, 2015
    Recount Blogs Oct 17, 2015

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page