Call macro for the sheets selected in listbox

Please help me
what is wrong with my code, i can't seem to loop the code for the sheets that I have selected using the listbox.

please see my codes here and advise what i need to change.

Please Login or Register  to view this content.

This is my userform listbox

Please Login or Register  to view this content.

This is the button where I want to run the macro for the sheets selected.

Thanks protonLeah

Do I need to use the For i = 0 To ListBox1.ListCount - 1 if in my listbox i'm selecting by the sheetnames?
Can I just loop the codes for the sheetnames instead of by selecting the sheet?

I can't seem to get it right, maybe is because in my listbox I'm excluding 3 sheets (Vessels, Location and summary)


Can you teach me how to just select the sheetnames?

i keep selecting the sheets that i have not selected... is there something broken in my first code for the userform?

i wanna cry...

still no luck.


i'm able to populate all the sheetnames in my listbox in the userform.

Now i need to run a code on each of the sheets selected from the listbox.

how do i do this?

Thanks protonleah

yes, i have got it solves in another thread.

here is the sample file that i have successfully done it.

just to share to anyone who is going through the same problem.

Combine Success1.xlsm