Filling a listbox with unique entries in a row based on certain criteria

Hey everyone,

I'm still fairly new to VBA and am trying to create a - by my standards - complicated sheet with control elements. The idea is that the user chooses two data properties in two drop down menus. Then, the listbox is supposed to fill with unique values that are based, or filtered if you will, depending on those properties.

For the filling with unique entries I am currently using a collection code that I borrowed from another forum post. It looks like this:

Please Login or Register  to view this content.

Now what it's supposed to do is to look within the row of a cell whether the properties selected in the dropdown menu are met, and either add or don't add the unique entry to the listbox depending on that.

The cool thing about the above code is that it's very fast, as the list I'm dealing with is quite big. Is there any way to accomplish this, or do I need to rethink the entire filling code?

Thank you very much in advance

PS: I meant entries in a COLUMN in the title, not a row.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)