Re: Counting items in a list box?

[Charles Yeomans <yeomans at desuetude dot com>]

You have to test.

dim count as Integer
dim i as Integer

count = 0
For i = 0 to Listbox.ListCount - 1
  If Listbox.Cell(i, 0) = X then
    count = count + 1
  End if
Next
Return count

Charles Yeomans




On Wednesday, July 30, 2003, at 04:42 PM, Daniel Lee wrote:

> I know how to loop through and count all of the records, but how do I 
> only
> count the records that meet a certain criteria?
>
> Thanks,
> Dan
>
>
> On7/30/03 1:04 PM, "Will Leshner" leshner at ljug dot com wrote:
>
> > I don't believe there is any built-in way to do that. I think you are
> > just going to have to loop through all the rows and count them 
> > yourself.
> > Daniel Lee wrote:
> >
> > > Does any one know how I can count items in a list box based upon the 
> > > value
> > > of one of the fields?
> > >
> > > If I have columns A,B,and C. I want to know how many records there 
> > > are where
> > > the value of the data in column A = X?

---
A searchable archive of this list is available at:
<http://support.realsoftware.com/listarchives/search.php>

Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
.