Need to refine dependent drop down combobox code to find worksheet tabs

[Jim885]

I have the below dropdown combobox code that works perfectly.

Private Sub Worksheet_Activate()
Dim ws As Worksheet
Me.ComboBox1.Clear
For Each wh In ThisWorkbook.Worksheets
Me.ComboBox1.AddItem ws.Name
Next ws

End Sub

But now need to split this to two dependent dropdown lists/comboboxes.

The first dropdown combobox list should contain all worksheets that contain the name that appears to the left of a hyphen on the worksheet tab.

The second dropdown/combobox list should contain all the words that are to the right of the hyphen on the worksheets tabs that are from the first dropdown list.

Much the same as;

First Dropdown list
Ford

Second Dropdown List
Mustang
Explorer
Ranger
F-150

 

[dmt32]

Dave,
Thank you very much for this. It's amazing and works perfectly.
Sorry for changing my post to be more specific while you were working on the code.

Hi,

Most welcome & no need to apologise just fully explaining what you want saves time

Many thanks for feedback and acknowledgement to all who assisted, it’s very much appreciated by all.



Dave