I have three comboboxes that are on a VBA UserForm. Each gets data from
Dynamic Named Ranges (DNR) that are located on a hidden worksheet:

For Each cOffNam In ws.Range("NameList")
With Me.cboOffNam
.AddItem cOffNam.Value
.List(.ListCount - 1, 1) = cOffNam.Offset(0, 1).Value
End With
Next cOffNam

for all three boxes (cboOffName = "NameList" cboOffBadge =
"BadgeList", etc.) I am currently using "Case" statements but when the
information in the DNR change, I have to manually edit the code. Is
there a way to perform the "Case" function using DNR? (I have a
separate UserForm that edits the DNR, so this "new" code would simplify
things tremendously!!!

I am able to populate each box from these dynamic ranges, but would
like to be able to click one box and populate the other two with the
matching information. (Use cboOffName to populate the other two, OR
click cboOffBadge to populate the other two, etc.)

Thank you in advance!!!