Hello Everyone,

I am developing a Userform but have come across an issue regarding cascading comboboxes and dynamic named ranges.

I have a worksheet with columns of data. The column count can increase/decrease based on future requirements. The column headings have been placed into a dynamic named range (DnrSkills). Lets assume there are 3 columns set like this:
A B C ---------(DnrSkills)
1 Day Adv Night
2 Depart Hover NRF
3 Arrive Fly Hover

When my Userform loads, it automatically creates Dynamic named ranges based on the columns in the worksheet. I now have 4 ranges, DnrSkills, Day, Adv and night

Here is the issue that I would like help with:

Combobox 1 is populated using the dynamic range DnrSkills. The dropdown list contains Day, Adv, Night. (this works fine)

I need Combobox 2 to look at whatever value isselected in combobox 1 (lets assume Day). Recognise that 'Day' is the name of a Dynamic named range created when the userform opened, and therefore populate itself accordingly (Depart, Arrive).

I have searched online for a few days now, and cannot find a solution to a problem like this.

Is what I am trying to achieve possible? And if so, would you please help this novice out!

Thanks in advance.