I am writing an macro in VBA. I have a range of data that is filtered. I want that filtered data to be listed in my listbox within a userform.

For Example, I have a range of names of people who work at different companies. When I click on one of the companies in my userform. I want all the names of people associated with that company to appear in the listbox.