userform one combobox dependent on another

I have a userform that includes 2 combo boxes (cboRoadway, cboStreet). These 2 are dependent on each other. It is comparable to a city / state drop down list.
By selecting roadway AA, you would get a list of matching cross streets for AA.
By selecting roadway BB, you would get a new list of matching cross streets for BB.

cboRoadway list values are populated in my userform_initialize statement.

Scenario: user selects a roadway, then selects a matching street. The user realizes they chose the wrong roadway, so they go back and change the roadway.
I need the street list to clear and refresh so that they new street choices match the new roadway selection.

I hope this makes sense. Go easy on me since I've only done a handful of my own VBA projects.

Private Sub cboRoadway_AfterUpdate()
    Dim cStreeet As Range
    Dim ws As Worksheet
    Set ws = Worksheets("Data")
    Select Case cboRoadway.Value
        Case "AA"
            For Each cStreet In ws.Range("e1:e19")
            With Me.cboStreet
                .AddItem cStreet.Value
                .List(.ListCount - 1, 1) = cStreet.Offset(0, 1).Value
            End With
            Next cStreet
        Case "BB"
            For Each cStreet In ws.Range("f1:f15")
            With Me.cboStreet
                .AddItem cStreet.Value
                .List(.ListCount - 1, 1) = cStreet.Offset(0, 1).Value
            End With
            Next cStreet
        Case "CC"
            For Each cStreet In ws.Range("g1:g18")
            With Me.cboStreet
                .AddItem cStreet.Value
                .List(.ListCount - 1, 1) = cStreet.Offset(0, 1).Value
        
            End With
            Next cStreet
        End Select
    
End Sub

Originally Posted by snb

Do not use additem to populate a combobox or listbox

This will be sufficient:

Private Sub cboRoadway_AfterUpdate()
    cbostreet.list = sheets("Data").cells(1,1).offset(,cborailway.listindex+1).specialcells(2).value
End Sub

I suppose
roadways in column A
streets of first roadway in column B
streets of second roadway in column C, etc.

Is there additional code I need with the above replacement? I replaced my code in cboRoadway_afterupdate with the above code. It returns the values for cboRoadway. Is there additional code I need somewhere else to make the above line work?

Column1 - contains list of major roadways (cboRoadway) such as IH-35E, IH-635E, US-75
Column2 - contains list of streets (cboStreet) that cross only IH-35E
Column3 - contains list of streets (cboStreet) that cross only IH-635E
Column4 - contains list of streets (cboStreet) that cross only US-75

When the user selects US-75 in cboRoadway, I want only the list in Column4 to appear in the cboStreets list.