Hello,
Looking for help with a code to get the number of all items in a listbox where the 5th column is nothing:
Thanks in advance.
Dim i As Long Dim ListCount As Long For i = 0 To (ListBox1.ListCount - 1) If ListBox1.List(ListBox1 - 1, 5) = "" Then ListCount = ListCount + 1 'not sure where to insert the "i" Next MsgBox ListCount
Perhaps.
Dim i As Long Dim cnt As Long For i = 0 To ListBox1.ListCount - 1 If ListBox1.List(i, 4) = "" Then cnt = cnt + 1 'not sure where to insert the "i" Next i MsgBox cnt
If posting code please use code tags, see here.
Hi Norie,
That works but why does 4 refer to the fifth column?
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 ...
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Thank you for that, very helpfulOriginally Posted by YasserKhalil
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
kosherboy 
Register To Reply
Bookmarks