Quote:
Originally Posted by Deirdre Kelly
I'd like to choose a Learning Target from a drop-down list and, based on that selection, have the next drop-down list populate with objectives pulled from an excel workbook.
This must be doable, but I'm in over my head and the answers to similar questions on this forum leave me in the dust. Have tried finding videos on YouTube, but have not had any luck.
I've created the lesson plan format - I just need to link/connect the first drop-down to the next one and then connect that one to the excel pages.
|
The code in
https://www.msofficeforums.com/word-...html#post46287 does that kind of thing. What it requires is an appropriately-designed workbook, with all the data for a given selection in the first dropdown to be on the same row. Of course, you'd also need to edit the code to reference the appropriate workbook and content controls.
Without seeing your workbook and the document you want to update, it's impossible to provide specific advice. You could attach both to a post (delete anything sensitive) via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.