Populate ListBox from Table and perform Filter based on CommandButtons

[AndyEd]

Can anyone help me.

I'm trying to populate a ListBox from a Table and then use CommandButtons to filter the entries that are displayed in the ListBox.

I've read of various ways to populate the ListBox and even managed to perform filters but I simply don't understand the code and the more I read and tried different things the more confused I became.

For instance I know I can populate the ListBox using the Rowsource feature but understand that it shouldn't be used, but I can't seem to find the reason why that is the case.

I've attached a workbook with the basic elements in it but no code. Can someone please point me in the right direction? I don't mind doing the leg work in order to try and figure things out but as I've said, the more I look the more I'm getting overwhelmed.

I guess this seems like i'm too lazy to work it out myself but it is what it is.

Thank you.

[torachan]

Attached small demo using your form.
Selection in listbox will populate the bottom three textboxes.
Also pressing each of the command buttons will fill the top three label boxes.
All the listbox settings are set up in the UserForm initialize event.
The table is loaded to an array and this is used to populate the listbox.
With an array this remains in memory and can be accessed without need to read the sheet.
The reason rowsource is not used for serious apps lies with the fact data is moved back and forth to the sheet at every activation of the listbox.
This in itself is inefficient in larger apps and has proven to be unstable for reasons I am not sure of(probably stack overload).
Look through the code, any problems post back on this site, hope this is of some small help.
torachan.