HI, I was trying to stay away from macros...my users are sometimes challenged by having to enable macros....

But I will take a look at the mapping potential.

Building on what was recommended earlier i.e. using table cells to pull/reference content controls. In my summary table I've linked to the content control value (text) which is B2 of the summary table. I'm trying to convert the text comment "Highly Accomplished" to a weighted value, however it doesn't seem to work unless I use the bookmark ref.

here is the formula I'm using:


{ IF { =B2 }="Unaccept*" "0" { IF { =B2 }="Develop*" ".25" { IF { =B2 }="Fully*" ".50" { IF { =B2 }="Commend*" ".75" { IF { =B2 }="Highly*" "1.0" "WTF" } } } } }

hi Greg,
I'm using word 2013, the mapping addin doesn't want to play nice. Anything to do with mapping or closing even causes word to crash. probably needs a clean install!

I forge forward albeit slowly...

thanks

The simplest way remains as per post #4 and, if you want to enforce the auto-updating of the calculations, use a ContentControlOnExit macro code as:

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Paul,

Perhaps I'm missing something. I don't believe you can get a cross reference to a non-numeric value in a table cell e.g., cell content = "Highly" and the OP indicates aversion to macros.

The OP can display "Highly" in a dropdown CC and store the value 1 in the node. Accordingly it seems to me that if the OP will accept macros then #15 may be easy enough.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Ah, I hadn't seen silverspr's last post (#16) when I replied - the forum software only advises of the first reply after one's last visit and, when I replied, didn't see that the thread now has a second page. I agree that formulae won't work for cells containing text - they can be used for retrieving the numeric content of cells containing alpha-numeric content, but not the text. Accordingly, the only viable option will be to either:
• switch from content controls to formfields and use field coding for the calculations; or
• drive the whole process via a ContentControlOnExit macro, with or without the mapping you suggested.

silverspr: If you store the macro in the document's template and store the template in a trusted location, there'll be no need for your users to enable them each time one of these documents is created/opened.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Works fine here with 2007 through 2016. I don't know where you are but it could be your regional settings. You can try mapping your document with that macro I sent you or send your document to me and I'll try to map if for you.

You can use the feedback link on my website to contact me.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Hi Greg
still couldn't get the CC add-in to work after an office 2013 reinstall and repair. The macro worked though!!! The mapped CC are fantastic...it stores the value from the combo box another bonus. And its simple to use! Thank u thank u! Is there a way to get both the title and value property from a combo box using this method? I know I'm pushing the envelope but thought I'd ask....actually I could store the value as alpha numeric!

Since the nodes are built based on the CC title, oNode.Basename will return the node name and hence the title. Note however that nodes names can't have spaces so any space in the CC title is replaced with an underscore.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Is there anyway you could send me website feedback using the Contact link on my website? I would like to test you document here to see if it crashes the add-in here.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

sure will do