vba to count specific items in listbox

[kosherboy]

Hello,
Looking for help with a code to get the number of all items in a listbox where the 5th column is nothing:

Please Login or Register  to view this content.

Thanks in advance.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[kosherboy]

Hi Norie,
That works but why does 4 refer to the fifth column?

[YasserKhalil]

As for listbox's rows begin with 0 so row 1 is row 0 and so on
The same with columns the first column is column 0 / The second column is column 1 and so on
And column 4 mean column 5

That's it is zero based ...

[kosherboy]

As for listbox's rows begin with 0 so row 1 is row 0 and so on
The same with columns the first column is column 0 / The second column is column 1 and so on
And column 4 mean column 5

That's it is zero based ...

Thank you for that, very helpful