ListBox Code for VBA form

I'm currently creating an invoicing system using a VBA form which is going really well however, I am now stuck with what I am hoping to achieve next.

Everything is working great in terms of adding data to the form and using the 'Add' command button to store the data on a worksheet, but I am now trying to implement the next function...


1. A ListBox to then be able to use the 'Find', 'Amend' 'Delete' functions etc.


My idea for this is to display all invoices in the ListBox at the bottom of the form with a scroll bar on the right hand side.

I would like to then be able to click on whichever invoice necessary and then have the data displayed on the form for me to make amends/changes or even delete a row if needed (I already have the code for the Delete ComandButton but obviously this won't work until the form can load data back into the form fields so it knows which row is to be dleted).

I'm only asking for a starting point or recommended tutorials

Cheers!