Add Last Six Items to Listbox From dynamic range

All,

I am trying to build a module to show the user the last 6 recorded invoice transactions they have entered into a table. The dynamic table is comprised of invoices and payments. Currently, the code I have below shows 6 invoices starting from the last 50th invoices due to this code:

Please Login or Register  to view this content.

. Of course, this is not what I want the module to do and would like to stay away from the hard count of 50. Can you please let me know how to get it to look from the bottom of the table and pick the last 6 invoices and add them to the listboxes?

This is what I have so far:

Please Login or Register  to view this content.

Thank you in advance for your help!

Thank you for the quick reply Norie! I am not sure where to place your line of code. Can you please let me know where I need to stick this in? Sorry about the newbie question. Thank you again!

Yes. Is this how I need to do this? If so, I am getting a Run-Time error: Object doesn't support this property or method.

Please Login or Register  to view this content.

Wow that looks simple and very clean! Thank you for that. I am getting a Subscript out of range error though. Do you might know why this error is popping up?

Thank you!!

Thank you again Norie. The module opens up without any errors but it seems that the listbox called 1stInvoices is showing null values. Can you please let me know why this could be happening? I have real data in the table and don't know why it isn't showing up with any values.

I have to attend a meeting right now and will be back in an hour and a half. I will provide you with a workbook but with dummy data when I return. Thank you for your patience and help!!!!

Norie, I'm going to mark this as solved. Your code did exactly what I wanted it to do. I messed something up on my end because I was in a rush to get this thing done. But after taking some time and really looking at my code, I got it to finally work! Thank you for your help! Your code did the trick!