Count function in ListBox

[azhar2006]

Hello all
I want to use the Count function to calculate the number of rows in ListBox. How do I write the function? I know how to use it in a continuous form, but I don't know how to use it in ListBox .
Thanks in advance

 

[theDBguy]

Not Count, but try using ListCount.

 

[azhar2006]

Not Count, but try using ListCount.

Thanks DBG for the quick reply. Frankly, I don't know how to use ListCount .

 

[theDBguy]

Thanks DBG for the quick reply. Frankly, I don't know how to use ListCount .

Should be as simple as:

Msgbox "There are " & Me.Listname.ListCount & " items in this Listbox."

 

[azhar2006]

Should be as simple as:

Msgbox "There are " & Me.Listname.ListCount & " items in this Listbox."