PDA

View Full Version : [SOLVED] Multi select list box



gibbo1715
08-31-2005, 12:24 AM
hopefully this is a simple question but one I have never tried before.

I have a userform listbox with the multi select properties activated (i.e. the checkbox on the left is active), how to I loop through the list and for example show a message box for each one that is selected?

Cheers

Gibbo

Killian
08-31-2005, 01:26 AM
This should do it


For i = 0 To ListBox1.ListCount - 1
If ListBox1.Selected(i) Then
MsgBox ListBox1.List(i, 0) & " is selected"
End If
Next

gibbo1715
08-31-2005, 02:13 AM
Perfert as usual

Thanks again

Gibbo