Best way to associate combobox entry to source custom collection

[grNadpa]

Based on my client's selection, I want to retrieve a Class Module ("clsRoster") object from the collection that corresponds to the client's choice without rolling through the entire collection ("colVendors" or "colClients") looking for a match. Entries in the relevant combobox are built from a subset of one of those collections.



Pretty basic. But I'm overwhelmed my search results for "Combo box", "value", "Column Bound" etc.. So please indulge my illiteracy.

I have half-a-dozen word 2016 forms ("Partial Waiver", "Final Waiver", "Maintain Roster", "Notary", "Invoice" et. al.) combined into one project. Most of them share data from a "Roster.xlsx" Excel file that contains sheets entitled "Vendors" and "Clients". Because I am quite adept at locking up that excel file with my VBA testing, and because there are so few entries, I've opted to render those sheets into custom collections ("colClients", "colVendors"). I populated those collections with a class module ("clsRoster") built from each populated row of the appropriate spreadsheet. Depending on the form, the combobox I load (.additem) is a subset of the entries in the relevant collection. And then only the clsRoster.name field. Based on my client's selection, I want to populate a clsRoster object from the collection that corresponds to the client's combobox.listindex

Again, the combobox entries are often a subset of the collection (e.g. clsRoster.name where clsRoster.IsActive = True) And though they will be ascending, they will not be consecutive. (e.g collection will have, say, records 1, 2, 3, 4, 5, 6 where as the combobox will have, say, records 2,3, 5)
Most of the solutions I've devised are quite cumbersome. And, again, the Google search results are overwhelming.

[grNadpa]

Found my answer(s) in Greg Maxey's Populate Userform Listbox or Combobox