Populating Combobox Based On Selection Of Another

I have a problem involving two combo boxes in a user form.

I need to populate different “lists” to combo 2, based on a selection in combo 1.

I browsed through the forum but could not find any solution that made sense to me.

Here are the specifics:
Combo 1 (called Cbo_Act) is populated with a list based on a named range in one of the sheets. The range is named “activity” and holds 2 records (“Income” & “Expense”).

This list is loaded as part of the form initialization.

If the user select “Income”, I need combo 2 (called Cbo_Act_Type) to show a list of various income types (derived from a dynamic named range called “Income_type”) and if the user selects “Expense”, I need the same combo box (Cbo_Act_Type) to show a different list, specifically – a list of various expense types (derived from a dynamic named range called “Expense_type”).

I know that this should be with a Cbo_Act_Change () routine, but for the life of me, I can’t figure out how to do it.