Dependent comboboxes on userform

Hello everyone
I have a code in userform that enables me to get dependent comboboxes on userform
In my sheet I have Columns C & D and E that should be related to three comboboxes ..
In userform initialize I got the unique values of column C in combobox1 and that's ok ..
If I clicked combobox2 I should have a unique list of related items of combobox1 and that's ok too

My problem is with combobox3 ..as I have all unique values for that item ..I need just to get unique values for that item based on both combobox1 and combobox2 ..

for example:
If I select "Cairo" in combobox1
I got "Schools" only iin combobox2 and that's ok
I expect to get Place10 to place17 only in combobox3 (but I got place10 to place22)
Hope it is clear

Here's my effort.

Thank you very much Mr. LeoTaxi for great help
Yes that's exactly what I need
Now how can I get the description in the textbox after change in combobox3...?

Thanks a lot Mr. Tinbendr for help .. you helped me in another point which is the textbox ..
But the main problem with combobox3 still as it
I tried to use your solution related the Description but I failed. Can you show me how to apply this point on Tinbedr's file?
Best Regards

Any help related the Description textbox ..?

Increase the column count of Combobox3 to 2.

Store the row number of the match to Column 1. (Columns start at 0.)

In the combobox3 change event, use the stored row number to present the record to the Desc Box.

Please Login or Register  to view this content.

Thank you very much for helping me again
In fact I tried to follow your steps and put the code in ComboBox3 change but don't know what x variable refer to?
I tried this but got an error

Please Login or Register  to view this content.

Can you post the whole code for me?
Thanks advanced for help

What is my example not doing?

Hello Mr. Tinbendr
Please revise these lines again

for example:
If I select "Cairo" in combobox1
I got "Schools" only iin combobox2 and that's ok
I expect to get Place10 to place17 only in combobox3 (but I got place10 to place22)
Hope it is clear

As for your post 3 is working as for textbox but doesn't solve the main problem which is not to list all the places in combobox3 .. Just list the places related to "Sector" AND "Tasneef" ..so as in my example it should list onle "Place 10 to Place 17" in combobox3
Hope it is clear

Every point is solved well separately but I couldn't apply the two points together

OK, I think I've got it now.

Thanks a lot Mr. Tinbendr for this great help and it is working well as expected exactly
But is there a way to abbreviate the code as I noticed in the combobox2 change you used most of the lines in the sub

Please Login or Register  to view this content.

Can the previous sub include the code in combobox2 change to avoid redundancy?
Thanks a lot for supporting and helping

No, since they perform different tasks.

Thanks a lot for help ..
I will try understand the structures so as to simplify the code a little and if I could do that I will post again
Best regards

Any suggestions about how to abbreviate the code provided in post 11?

Mr. LeoTaxi
Thank you very much for this great and wonderful solution
You have solved it in an easy and perfect way ...
Best Regards