Adding/removing items - listbox1 and listbox2

[yoko21]

I have 2 listbox. Listbox1 has a list of reports with specific macro for each report. I have successfully made a code to add a selected report from Listbox1 to Listbox2 once the add button is pressed after the selection. I have also successfully made a code to delete a selected report added in Listbox2.

Now my problem:
1.) How can I do multiple selection in Listbox1 to add in Listbox2?
2.) How can I do multiple selection in Listbox2 to remove multiple selected reports?
3.) A report can only be added once. How do I make this limitation and prompt a message that the report has already been added?
4.) Another problem I noticed is when the user remove the last report added in Listbox2 it will clear all previously added reports.
5.) How do I transfer the list of reports added in Listbox2 to cells (say Sheet1)?

Here is my code:

Please Login or Register  to view this content.

Cheers

[yoko21]

Question 1, 2 and 4 solved. I need answers for 3 and 5. Thanks

[yoko21]

silent Bump for limiting duplicates

[yoko21]

anyone please?

[yoko21]

no one? ....

[yoko21]

silent bump... please..