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.

Please Login or Register  to view this content.

Originally Posted by snb

Do not use additem to populate a combobox or listbox

This will be sufficient:

Please Login or Register  to view this content.

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.