Content Control values NOT display name
HI
I have two content controls: CC1 and CC2 in separate tables
CC1 is a dropdown showing the display name:
Display name Value
meets 0.25
exceeds 0.75
I would like CC2 to show the value such that if CC1=meets, then CC2=0.25
I've tried the REF function and VBA to set the value but I can't get it to work, it seems the control created with ref takes the name of the control its referencing. Right now I'm exploring nested IF statements...these look messy!
any help is appreciated
thanks
|