How to populate Listbox with last 5 rows of data

Hi guys

I have done a bit of a search and not found quite what I am looking for, This may be simple for some of you I hope, What I am trying to do is populate a userform listbox with the last 5 rows of data from column A, The list of data in column A is always changing (Can be 10 rows, 30 rows, 100 rows) So I am just trying to pull the last 5 rows and add them to a listbox, any help would be appreciated

Example: Column A contained a list of numbers 1-23 then the listbox would populate....

19
20
21
22
23

Column A contained a list of numbers 1-35 then the listbox would populate....

31
32
33
34
35

Seems easy but I am struggling
Kinds regards
John

Assuming ListBox1(name of control) and Sheet1(sheet name)

Please Login or Register  to view this content.

Works great, thank you very much

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

jindon

Is there any way to stop the error when there are LESS than 5 items in column A ? works great but obviously its trying to add the last 5 rows when there are only 4 ?

Regards
John

Change to

Please Login or Register  to view this content.

Thank you, solved