Display Listbox Source in reverse

[paublojobino]

Hi experts,

I have a Userform which contains a listbox for which i am setting the source on Userform_activate as per below:

Dim sh As Worksheet
Set sh = Sheets("tordata")
Dim lr As Long
lr = Sheets("tordata").Range("a" & Rows.Count).End(xlUp).Row

Sheets("tordata").Activate
With Me.ListBox1
                     .RowSource = "a4:CC4" & lr

How can I display the data is the listbox in reverse order (so the most recently added data displays at the top, not the bottom?)

 

[Micron]

Google suggested this

Sorting ListBoxes with VBA - Excel Off The Grid

I received a question from a reader recently, who wanted to sort a Listbox using VBA. As this seemed like a common problem which many users could face,

exceloffthegrid.com

 

[paublojobino]

Google suggested this

Sorting ListBoxes with VBA - Excel Off The Grid

I received a question from a reader recently, who wanted to sort a Listbox using VBA. As this seemed like a common problem which many users could face,

exceloffthegrid.com

I have tried these google solutions to no avail

 

[Micron]

The fact that it works for some but not you suggests you missed something. Maybe that your listbox is populated by a range but the example uses an array? So since you can't reverse the order of your cells the missing something might be putting the range values into an array first, then reversing them?