Quote:
Originally Posted by macropod
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).
|
-- 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.
Quote:
Originally Posted by macropod
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. |
-- 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.
Quote:
Originally Posted by macropod
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).
|
-- Looks fixed. Thanks.
Quote:
Originally Posted by macropod
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.
|
-- Thanks!
Quote:
Originally Posted by macropod
I've enhanced the code a bit and made the cell formatting more consistent for all items.
|
-- Thanks!
Quote:
Originally Posted by macropod
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.
|
-- 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.)