Select Multiple Items in a ComboBox (VBA) ???

[Terry_Orange]

Given that I have a combobox that shows all of the files on my floppy disk, I would like the user to be able to select multiple files from this disk for an action to be done to just those files.

Does anyone know how this can be done, if it is at all possible ? If not, is there any work-around using a different technique or has anyone used a different method to achieve the same ends ???

Thanks

TO.

 

[Expel]

Use a listbox

Set the multiselect property to true

 

[Terry_Orange]

I like nice and easy replies like that - even it makes me look stupid !

THANK YOU. Much appreciated.

TO.

 

[Terry_Orange]

If I want to access this information from a multiple selection, how do I recall this ?

To get a single piece from a combobox I am using

comboBox1.List(comboBox1.ListIndex)...

any ideas for this multiple selection of a listbox ?

Thanks
TO

 

[Andrew Poulsom]

Like this:

For i = 0 To ListBox1.ListCount - 1
   If ListBox1.Selected(i) Then
'     ** Your code goes here ***
   End If
Next i

 

[Tejas]

How does the cell linking work with multiple selections?