Excel VBA: Multi-level dependant lists ComboBoxes. some problem in extracting unique lists

i have a file containing the sample userform of 3 sample combo boxes every next combobox is dependant to the previous.

there is a simple vba behind it, which i think should work correctly.

Please Login or Register  to view this content.

it does work for starting items but not for further. the issue is in

Please Login or Register  to view this content.

as well as in

Please Login or Register  to view this content.

when it try to get unique items for combobox list.

any solution please.

Comment: The query is also posted by me in MrExcel forum.

Cross posted
https://www.mrexcel.com/board/thread...lists.1177309/

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

Originally Posted by jindon

Please Login or Register  to view this content.

thankyou, sort goes correctly but there is a little issue still present. on top of dropdown list i found a blank row. any way to remove that blank row?

for a temp patch i am using

Please Login or Register  to view this content.

iAgentName is Combobox1 in this case

is that ok or should do with some other better way?

it worked. thank you!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.