Reversed rowsource in combobox

[hentie]

Can anyone help me?

frmNCREdit.ComboBoxEditNCRNo.RowSource = "B2:B" & rEnd

I wish for the data displayed in my combo box to be in reverse order.
for example the source rows "B2:B" & rEnd contain this data

1
2
3
4
5

so the Row Source shows data B1:B5

however I wish the data to be displayed in the combobox in a reversed order.

5
4
3
2
1

so I would assume the Row Source should show data B5:B1
but this doesn't change anything in the combobox
can anybody suggest how I can have my data in the combo box displayed in reverse order?

Many thanks

 

[Sal Paradise]

You can't just reverse the order of B1:B5 so that it reads 5 4 3 2 1 instead?

 

[hentie]

No. It is a list that get added to all the time and the list got so long now that it take some time to scroll down. The list is also sorted by date. Now I want the bottom data in colomn to appear on top of my combobox.

 

[mikerickson]

Dim i as Long

With frmNCREdit.ComboBoxEditNCRNo
    For i = Cells(Rows.Count,2).End(xlup).Row to 2 Step - 1
        .AddItem Cells(i,2).Text
    Next i
End With

 

[hentie]

Thank you mikerickson. Your solotion worked very well for me.