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.