Multiple selection in listbox

[johnrb7865]

Hello, I have 2 listboxes where if you select an item in one then click the
add button it will place it in the other listbox. I want to be able to select
multiple items in the first box and have them all move to the other. I set
the listbox properties to multiselect and it does let me select many, but it
will not let me move them to the other box. Any ideas?

Thanks,
John

 

[Wigi]

In any case, you will have to write a loop through the items of the listbox,
and check whether they're selected or not.

See:

http://www.dailydoseofexcel.com/arc...eve-values-from-a-multi-columnselect-listbox/

or

http://www.dailydoseofexcel.com/archives/2004/04/27/using-multiselect-listboxes/

If selected, then use AddItem to add the selected item to the second listbox.

 

[Dick Kusleika]

Hello, I have 2 listboxes where if you select an item in one then click the
add button it will place it in the other listbox. I want to be able to select
multiple items in the first box and have them all move to the other. I set
the listbox properties to multiselect and it does let me select many, but it
will not let me move them to the other box. Any ideas?

It won't do it automaticallty, you have to write code to make that happen.

http://www.dailydoseofexcel.com/archives/2004/04/27/using-multiselect-listboxes/