Reversing rowsource order for a multicolumn listbox

[wackywoo105]

I have a 3 column list box in the format:



A1 A2 A3
B1 B2 B3
C1 C2 C3

The rowsource for this contains A1;A2;A3;B1;B2;B3;C1;C2;C3

I want to reverse the order so I have

C1 C2 C3
B1 B2 B3
A1 A2 A3

Which would give a row source of C1;C2;C3;B1;B2;B3;A1;A2;A3

Does anyone have a piece of VBA code that would manage this?

[orange]

Can you tell us more about Why you need this?
Can you not just type it i?

[wackywoo105]

The listbox contains a filename, date and description in each of the 3 columns. I do not know what it will contain until some other VBA code populates it. The number of rows also varies. Currently the newest file is shown at the bottom but I want it reversed so it is shown at the top.

How do I reverse the rowsource property in the maner described?

[orange]

Normally the rowsource would be a query (SQL statement), and to reverse it you would change the ORDER BY clause.

[wackywoo105]

The listbox is populated using additem so there is nothing to order until after this has happened.

All I then have to work with is the rowsource. There must be a simple way to rebuild it in reverse but jumping 3 ";" at a time.

[June7]

I think the code will have to add the rows to the list in the order you want. Where are these values coming from?

[wackywoo105]

Having slept on it I have figured out how to build the rowsource as a string in reverse instead of using additem. I don't know why I was struggling to come up with this.