none
How to get a count and values of a column of values RRS feed

  • Question

  • Hello,

    I'm working on a user form and I'm dynamically adding labels and checkboxes.  What I need to know is how I can look at a column in a hidden sheet that lists all the projects I want to show and get a count of how man there are.  Once I now this I will create a row for each project with 7 checkboxes one for each day for each project row.

    Thank you for any help

    Wednesday, April 29, 2015 3:35 PM

Answers

  •     Dim iCnt As Integer
        iCnt = Application.CountA(Worksheets("Hidden Sheet").Range("A:A"))
        MsgBox iCnt

    If you have a header, remember to subtract 1.

    • Marked as answer by Jerry8989 Wednesday, April 29, 2015 4:01 PM
    Wednesday, April 29, 2015 3:43 PM

All replies

  •     Dim iCnt As Integer
        iCnt = Application.CountA(Worksheets("Hidden Sheet").Range("A:A"))
        MsgBox iCnt

    If you have a header, remember to subtract 1.

    • Marked as answer by Jerry8989 Wednesday, April 29, 2015 4:01 PM
    Wednesday, April 29, 2015 3:43 PM
  • Thank you so much that did it. 

    Wednesday, April 29, 2015 4:01 PM