Count Items in Listbox

**Mike_e** · 10-17-2011, 10:13 AM

Hi,

I'm looking to count the number of items in a listbox on a form using vba. Can anyone help please

Many thanks

**royUK** · 10-17-2011, 10:14 AM

ListIndex+1

**Colin Legg** · 10-17-2011, 10:17 AM

Debug.Print ListBox1.ListCount

**Mike_e** · 10-17-2011, 10:40 AM

Many thanks guys for your speedy responses. Invaluable as ever!!

**Isaacadete** · 05-25-2017, 07:44 AM

Hi Guys I have the same concern, but I didn't understand the solution.
how can I have count of checked items of the listbox on cell?

**FDibbins** · 05-26-2017, 02:12 AM

Isaacadete Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.