I know of no way, in VBA, to reach the "value."
That may simply display my ignorance (which is vast).

I would code in a test for the text and use that to determine the abbreviation to be used. This could be in a separate and hidden content control rather than in the vba.
See Linked Content Control Drop-Down List.