Instead of a vba solution, consider simply using a mapped content control. The choice will be reflected in each copy of the control.
Instead of a vba solution, consider simply using a mapped content control. The choice will be reflected in each copy of the control.