R
Robert Couchman
Hello all,
i am after some help or guidence.
i have a statistics userform that displays all the results
of an ethnic monitoring form.
the details held need to be seperated (e.g. when i use the
filter to determine who passed.
the way my monitoring sheet works is by using the VB code:
tb1.Text = CStr(WorksheetFunction.CountIf(Worksheets _
("Sheet1").Range("E:E"), "TRUE"))
this will display all results to the answer true in column
E, but when the filter is on, it still puts all the
answers into this textbox!!!
is there anyway of filtering my records and still keeping
track of the ethnic monitoring??
thank you,
Robert Couchman
([email protected])
P.S. i have considered using sheet2, but i thought there
would be an easier way!
i am after some help or guidence.
i have a statistics userform that displays all the results
of an ethnic monitoring form.
the details held need to be seperated (e.g. when i use the
filter to determine who passed.
the way my monitoring sheet works is by using the VB code:
tb1.Text = CStr(WorksheetFunction.CountIf(Worksheets _
("Sheet1").Range("E:E"), "TRUE"))
this will display all results to the answer true in column
E, but when the filter is on, it still puts all the
answers into this textbox!!!
is there anyway of filtering my records and still keeping
track of the ethnic monitoring??
thank you,
Robert Couchman
([email protected])
P.S. i have considered using sheet2, but i thought there
would be an easier way!