Hello Everyone,

I am trying to make a userform to show a list of items that each person is holding in their "account". I have chosen to use a combobox to select the Account name, this is done.

I am having trouble with the listbox to show the list of items though. What would be needed is very similar to vlookup I think because the macro would take the name from combobox1, which is taken from a list on a sheet called "deposits", columnA. Listbox1 would simply need to look down columnA and show the item name, from columnC for each item with that account name.

Column A and Column C would go down to row 23000 and there is no limit to the number of items that can be attached to the same account - just in case that matters.

If any more information is needed, I'd be happy to provide it. Many thanks in advance