Count number of selected items in a ListBox

[rockchalk33]

There has to be an easy way to count the number of selected items in a ListBox and display them in a message box?

Please help,

Thanks

Devin

 

[My Aswer Is This]

This is a duplicate posting from you on this same forum within the last several days. Please wait for an answer and if after a certain time I'm not sure what it is your allowed to do a Bump. See forum rules for details. But do not post the same question more than once.
Your previous post was here:
http://www.mrexcel.com/forum/excel-...ore-than-1-listbox-selection.html#post4664273

 

[My Aswer Is This]

edit

 

[My Aswer Is This]

Try this:

Private Sub CommandButton13_Click()
For i = 0 To ListBox1.ListCount - 1
    If ListBox1.Selected(i) = True Then
        Numselections = Numselections + 1
    End If
Next i
MsgBox Numselections
End Sub

 

[rockchalk33]

Try this:

Private Sub CommandButton13_Click()
For i = 0 To ListBox1.ListCount - 1
    If ListBox1.Selected(i) = True Then
        Numselections = Numselections + 1
    End If
Next i
MsgBox Numselections
End Sub

Thats what I needed! Thanks! Sorry about the duplicate posting

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

Thats what I needed! Thanks! Sorry about the duplicate posting