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).
They might appear to be the same, but that's only because you have the same objectives on all worksheets.
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).
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.

Attached Files

Lesson Plan MASTER.docm (57.9 KB, 22 views)

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

-- So... is there no way to get it to do what I need it to do? Select from 7 Domains, then select one objective from a list of 30-40 objectives?

-- I've attached a new spreadsheet.... with the progress levels removed.... placed at the ends of each objective.... hoping that might help us?

-- I like the idea that the objectives, once selected can be edited. That's helpful.
-- I must be doing something wrong then - because when I choose Knowledge, the same objectives show up as when I select Leadership. The objectives on each page of the worksheet are different.
-- Looks fixed. Thanks.
-- Thanks!
-- Thanks!
-- I like the idea of not being able to select from LT 2-5 until LT 1 is selected.
-- There can be a need to select the same LearningTarget repeatedly - one lesson might have 2-3 objectives from the Knowledge list. (We would not select the same objective repeatedly.)

Attached Files

Master List of I Can Statements 2.xlsx (20.7 KB, 24 views)

I now see what you meant byFixed.

I've also added the code to prevent LearningTargets 2-5 until something is selected from the previous LearningTarget.

The attached template contains none of the workbook data - which is how you'd normally store such a template. Double-clicking on it should create a new document with the data.

I have retained the code that works with your original workbook structure; I see no advantage in changing it. That said, I'm not sure what you mean by:
Do you mean that, if you choose Knowledge, the choices that become available are all of the entries on that sheet? If so, you could only choose one of those 30-40 entries, whereas the current process allows you to output all that are applicable to Distinguished, for example, and gives you the ability to delete any you don't want and/or to re-word the ones that are there.

Attached Files

Lesson Plan MASTER.dotm (51.6 KB, 18 views)

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