Making Dependent ListBox or ComboBox from Pre-Made Validation List

I have not found success from my previous post; so I am thinking it is because my title from the other post was throwing people off.

Essentially I have a validation list that populates from a list. I am going to put a ListBox or ComboBox on top of the validation list. How do I get the information in the validated list to automatically show up in the ListBox/ComboBox? I am unable to use the normal way of ranging the ComboBox/ListBox and has to be linked to the Validation List.

An example is attached.

Thanks!

I have a UserForm that populates a department. Based on what department it is, the validation list automatically changes based on the SUBSTITUTION that relates to the department. For that reason the validation list has the list of information. The problem is that I hate how Validation list doesn't have a drop down arrow and I don't like doing the "fake arrow." In it's place I am wanting to put a ListBox on top of the validation list. I have done it before, I just can't remember how it to code it

Essentially, I need the ListForm to mirror and update as soon as the Data Validation list does.

Set the ListFillRange property of list box to Sheet1!A1:A8.

It that what you trying to do?

Otherwise, where is your userform and etc?

Based on the workbook I am using I cannot set the Range to be the list of data. I need the ListBox to update based on purely the Data Validation. The attachment above is an example of what I am dealing with. I made the list, created the data validation, and created the ListBox. I need the ListBox to update and populate based on what is in the DataValidation.

I am trying to do this: List updates --> Validation List --> Validation List updates --> ListBox

Not: List updatess --> ListBox

Bump for answer.