I would use mapped dropdown content controls to remove the need to use vba at all.
See the attached demo which has a series of content controls all mapped to the same built in document property. Each drop down has two entries where the displayed text is controlled by the stored value.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|