Populate Content Control Dropdowns from Excel

macropod · #8 08-26-2017, 01:45 AM

Quote:

Originally Posted by Deirdre Kelly

When the Objective drop-down box opens, it shows the organizational structure of the objectives list (the subheadings of each list, like "Apprentice Intermediate"), rather than showing the organization as well as the whole list of I Can Statements.
----When I click on the Objectives drop-down list, I need to be able to see the organizational levels and all the I Can Statements so I can select one I Can Statement from the whole list.

There is a limit to how much content can be displayed in a drop-down. Amongst other things, items can only span a single line. When you select an Objectives item and exit the dropdown, its I Can Statements are added to the cell. You can change the selection, if needs be, to generate a different set of I Can Statements - or you could even edit them (if appropriate).

Quote:

Originally Posted by Deirdre Kelly

Regardless of which selection is made in the LearningTargetBox, the ObjectivesBox is showing content from the "Knowledge" list.

They might appear to be the same, but that's only because you have the same objectives on all worksheets.

Quote:

Originally Posted by Deirdre Kelly

Spelling mistake for the work "Intermediate"... I must have replicated it throughout.

If you find an error or want to change an I Can Statement, for example, simply edit the workbook, re-run the Document_New macro, then re-do the relevant dropdown selection(s).

Quote:

Originally Posted by Deirdre Kelly

There is something weird going on with LearningTargetBox3... when it accepts a selection it seems to lose its drop-down list after that?

That seems to be related to the cell's formatting being different from its predecessors and the fact the content control's 'cannot be deleted' property hadn't been checked. Fixed.

I've enhanced the code a bit and made the cell formatting more consistent for all items.

FWIW, I could also make the form work so that you couldn't select anything from LearningTargets 2-5 until you'd selected something from LearningTarget 1 and - with significantly more work - that the only items available for selection in LearningTargets 2-5 would be items that hadn't already been selected.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel formula while using dropdowns	rjf1127	Excel	12	01-25-2017 10:53 AM
How to populate dependent dropdowns and auto-fill text fields simultaneously?	vera	Word VBA	1	10-07-2016 07:41 PM
Populate Drop-Down Content Control from CustomXMLPart added to the Document	KhmerBoi1	Word VBA	0	05-11-2016 01:10 PM
Have Text Entered in Content Control / PreDefined Field Populate Field in Footer	bzowk	Word	1	04-14-2016 11:50 AM
Deleting a table from a content control -- preserving the content control	BrainSlugs83	Word Tables	8	11-14-2013 03:06 AM