Count a items in a column in a form listbox

[Rafael Mena]

It is possible to count the items in a specific column of a form listbox in excel vba?

[6StringJazzer]

It's not clear what your question is. All columns of a listbox have the same number of items. It's ListBox1.ListCount.

Do you mean count the occurrence of a specific item in a specific column?

Please Login or Register  to view this content.

[Rafael Mena]

Thanks for the fast answer. you right should be the same #s of data, but the data come from a Work Permit Database and I wan to know from a period requested in the form in a listbox some of the permit are not close

[6StringJazzer]

You just need to update the logic in the following conditional test (taken from the code above) to be what you actually want to test for.

Please Login or Register  to view this content.