Userform ComboBox populating Comboboxes from worksheet data

What I am trying to accomplish is having the agent name populate cbAgentName combobox based on cbMU as well as populating cbAgent combobox. Both these comboxes should act the same as cbSkName and lbMSN. If in cbMU I choose 100 then cbAgentName and cbAgent should populate with all agents that are in the group # 100 based on columns A:C
Also I need the lbData to populate as well but only with the agents that have skillnames and levels that do not match
So summary is lbData should show agents name, skill name, skill level sys1 and sys2 only if the skill levels don’t match but I want the data to be pulled from the columns A:G based on what they should retrieve and the lbData should stay blank till cbMU chosen then display one instance of each agent with mismatched skills. the cbAgent and cbAgentName can be filled like what the way lbMSN is setup but again one instance of each agent not multiples like on the worksheet.
Some background:
Listbox (lbMSN) & ComboBox (cbSkName) rely on what a person chooses under ComboBox (cbMU)

Worksheet GtoICheck has columns and rows that I need to populate Listbox (lbData) ComboBox (cbAgentName)
All columns are static and cannot be changed as the empty columns seen do have data that I had to remove.
The names of agents are dynamic so the range can vary even as deep as from A2:H1500
Columns R:T are the Sys1 reference and are the accurate point of reference
Column F pulls data for the agent but from a different worksheet
Column G is formula based to look for agent in Column A and pull that agents skill Level from another sheet but for this sample I placed the values in.
The colored cells (normally are conditional formatted) but just colored to reflect what is green is accurate and what is red is not. So level1 9 in Sys1 is =Level1 in Sys2 thus cell is green. (9=1, 5=5 and 0=0 are all accurate) but 9=5, 5=0, 0=9, 0=5 are not accurate thus they are red or would be in the conditional format formula

What I did so far is add an array in cbMU so when 100 is chosen it displays the skill names in lbMSN and cbSkName. You will also notice the skill level in lbMSN is also displaying but if you take a look at the array it is really time consuming to try and align as what I did. If there is a way to improve on the code I used I look forward to it as I have over 40 skills, skill names and levels that are needed to be added.
Columns R:T have the Sys1 MU’s, Skill names and levels and ideally should feed the cbMU results in lbMSN and cbSkName instead of using the array
I really need help on the first initial problem for the cbAgentName and cbAgent to populate the way I need it too. The array would be a bonus and accepted with total gratitude as well.

To give an idea for the array used and my apologies for ugly it looks

Please Login or Register  to view this content.

Any help is greatly appreciated.

You can loop through column C and get the results to populate the other combobox

Please Login or Register  to view this content.

Davesexcel that worked great in the sample with the exception it duplicates the name and I need to somehow add in the '.RemoveDuplicates' code but when I copied the code into the original it doesn't do what it's supposed to like the sample. I had to adjust the offset to 5 to pull from column H for the agents names but it worked great in the sample. Any chance you can let me know what the '23' is after 'xlCellTypeConstants' so I have a better understanding of the code? Any chance to adjust the code to look in column A for the name or should I just leave it as column H using offset 5?

I updated the code you supplied in the sample to include cbAgent and it works great for both comboboxes (except the duplicates at this point) but as mentioned it doesn't work in the original workbook and both comboboxes as they are blank and no error messages either.

well I thought I had the code to remove the duplicates in the combobox named cbAgentName but it didn't work.
I am not certain how to or if it's possible to add .removeduplicate in the following code as I keep getting errors

Please Login or Register  to view this content.

so I attempted updating the vba code in the cbAgentName combobox using the following code but it does nothing and doesn't error out
What am I doing wrong or missing? I don't want the sheet duplicates removed. Just want individual names showing in the cbAgentName combobox
Here is the code I thought would work (not my code but adapted it to my userform and sheet)

Please Login or Register  to view this content.

Anyone have suggestions to my dilemna?
Ultimately if I can get this working I will adapt the working code to include the cbAgent combobox but thought it would be good to work on one at a time.
I have alot of work left on this userform and once the duplicate removal works then I am going to look at whoever I choose in cbAgent when clicked will show in the lbData listbox with only the values that have mismatches from the conditional format I have on the sheet; but not on the sample I supplied.

Thank you to anyone who is willing to help a learning older guy

Like this.

Please Login or Register  to view this content.

You probably are using that damn Option Explicit.

Add this at the top of the code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Try the example file. It does how I understand your query.
Opening the UF some Comboboxes are prefilled. Selecting a MU populates AgentsName and Agents and gives all filtered searchresults from GtoICheck in Left side Listbox.
When filling all Comboboxes on the right and clicking Write writes results to Audit Data Tracker and fills below listbox with all data present there.
Don't know what you want with bot other Listboxes ?

For that I should need to see the original file or your example file should exactly match the layout, sheetnames, objectnames etc... as the original.

Glad you got it running.
You're welcome and thanks for rep+.