Listbox with unique and dependent items - VBA

Hi,

Sorry if this is a topic well discussed, but I have been working on this basic code to have it doing this:

I have a Listbox1 in which I was able to populate it with unique items (from columnB in Programmes worksheet) using a collection (that was a good achievement for me!)

Now, I want to populate a the Listbox2 with items (not repeated) from columnC, BUT only if the correspondent value on columnB is equal to listbox1.value.
Could you please help me finding a solution for this? I am just a beginner in VBA...

THANKS!

Please Login or Register  to view this content.

Hi,

please edit your post and use CODE tags for your code, you'll find a link how to do that in my signature.

In order to make your code work you have to place "On Error Resume Next" above the loop where the collection is filled.

Personally I'd suggest the usage of a dictionary:

Please Login or Register  to view this content.

Another one.

Please Login or Register  to view this content.