I have a source combo box (cboRegions) that contains the names of various regions.
Each region has its own radios.
I want a second combobox (cboCrews) to populate it's contents with a different range name depending upon the cboRegions value.
Each region has a range name associated with it (e.g. "Northwest"--"northwestradios"; "Southwest"--"southwestradios",etc.).
I will have to use a Select Case statement because I have several selections.
So, if cboRegions.value = "Northwest"
Select Case cboRegions.value
cboCrews.(value?rowsource?controlsource?) = northwestradios
What object do I use after cboCrews to link it to northwestradios- range, valuer, rowsource, controlsource?