Forum Discussion
Autofill/Cross Reference in Word Tables
I have a table in Word that I fill out before restricting the document and having users fill in the remaining form fields. I use a Drop-Down List Content Control to fill in one cell of the table and would like the result of that selection to return a name in a different cell. The content control is removed once the selection is made. Is this something that is possible?
When "System Name" is selected from the drop-down, I'd like the Liaison's name to automatically populate. System Name is cell B2, "Liaison:" is cell C2, and the name of the liaison would fill into D2.
ld How many entries do you have in the Dropdown list?
By using the ContentControl on Exit Event in the ThisDocument object, what you describe can be done.
At the following page of his website
https://gregmaxey.com/word_tip_pages/content_control_tools.html
Greg Maxey, provides an Add-in that simplifies many of the tasks of developing with Content Controls that are detailed on other pages of his website, starting with
https://gregmaxey.com/word_tip_pages/content_controls.html
Note: As you have added the Content Controls tag to your question, instead of using the Protection for Filling in Forms, you should use the Group facility in the Controls section of the Developer tab of the ribbon to prevent the text and layout of the document\template from being changed.
- There are 23 entries in the dropdown and specific selections will return one of 5 corresponding names. I've written an IF/OR formula to do the same thing, but in Excel.
My knowledge of content control is extremely limited, I only just stumbled across the settings we now have in place.- You will need to use the Visual Basic Document_ContentControlOnExit event, most probably with a Select Case construction to return the required one of the 5 names.
