Adding sheet names to listview

[killerofsix]

Here's my code:

Please Login or Register  to view this content.

Picture of the output:
listview.png

I know it's going to be something stupid but I've been stuck on this for too long now. How do I populate the listview so it adds items to the next row instead of the column beside it? I've been playing around with the listview properties but have hod zero luck in getting the listview to populate row by row.

Thanks to whoever helps.

[killerofsix]

For anyone that finds this:

Please Login or Register  to view this content.

Credit here: http://dailydoseofexcel.com/archives...2/26/listview/

[Norie]

Why not use a ListBox?

Please Login or Register  to view this content.

If you do want to use a ListView add this, or set the View in design mode.

Please Login or Register  to view this content.

[killerofsix]

Listbox won't work because I want a checkbox beside each item. Thank you for your reply though.

[Norie]

Yes it will.

This will display a checkbox next to each item in the listbox.

Please Login or Register  to view this content.

[killerofsix]

Thank you for that! When I started on this search to solve this problem I came across a post where it was stated that checkboxes can't be displayed in a listbox. Thanks for sorting that out