Need support to write code for multiple combobox filters for final combobox

Hi Team,

I am at learning stage in VBA please help me to resolve this issue. I am working on user form and for same I have done initial coding part, but now I need multi dependent combo box filters for final out put in different combo box. Below is the case

I have 7 combo box 1)Region 2) Location 3) Department 4) Team 5) Team type 6) Team costcenter 7) Employee Name

For 1 & 2 I wrote the code and now I need combo box filters basis on region-->under this region selection "team" and -->under selected team - "Team Type" and so on basis on selection finally I need Employee Names in combobox7

Data source for : Region, location in sheet 1 " 1 & 2" and in sheet 2 we have 3 to 4

Thanks in advance

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.