ListBox with multiple table sources

Hello everyone,

I have a userform with a listbox with the following code:

    Me.ListBox1.RowSource = "table1"

This shows me all values in column A from table1 in the ListBox.
However I would like to fill the ListBox with multiple tables. Let's say "table1" and "table3".

How can I achieve this?

Kind regards,

Marco

Hello royUK,

Good question. My sheet is an anime list, keeping track of all shows I watch.
On my first sheet I have multiple tables, like: "Watching", "Completed", "Planning to Watch", etc.
I have a code running which moves the rows to their corresponding table depending on the number of episodes I enter.

I didn't have this before, I used to have it in one table. But then I got the code for moving the rows, as said earlier.
When I used just the one table, I had a Named Range filling the ListBox, as such:

Me.ListBox1.RowSource = "NamedRange"

That still works, but now it shows the header for the tables below the first one as well...
Example:

Table1:
ColumnA
HEADER
Value1
Value2
Value3

Table2:
ColumnA
HEADER
Value4
Value5
Value6

The ListBox then shows:
Value1
Value2
Value3
HEADER
Value4
Value5
Value6

I don't want the headers to be in the ListBox. So that's why I wondered if it's possible to have more than one table as a source for a ListBox.

Kind regards,

Marco

Sorry for the late reply.

That's pretty much what I had, though basically trying something else now. I'll see what works best for me in the end.
So simple put: Is it possible to have multiple tables fill in a ListBox?

Kind regards,

Marco