Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2017, 07:34 AM
macropod's Avatar
macropod macropod is offline Populate Content Control Dropdowns from Excel Windows 7 64bit Populate Content Control Dropdowns from Excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the attached. Instead of trying to treat a graphic as a button - which would require a great deal more code - the user gets prompted to add a new row upon exiting the last 'Grade Level' or 'ObjectivesBox' content control in the table concerned - provided it's not showing the placeholder text.

Note: Because you have more content controls below whatever will be the final 'ObjectivesBox' content control, it was necessary to split that table in two. That shouldn't affect the functionality, however.
Attached Files
File Type: dotm Lesson Plan Template.dotm (59.8 KB, 27 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 09-06-2017, 08:38 PM
Deirdre Kelly Deirdre Kelly is offline Populate Content Control Dropdowns from Excel Windows 10 Populate Content Control Dropdowns from Excel Office 2013
Novice
Populate Content Control Dropdowns from Excel
 
Join Date: Aug 2017
Posts: 12
Deirdre Kelly is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Try the attached. Instead of trying to treat a graphic as a button - which would require a great deal more code - the user gets prompted to add a new row upon exiting the last 'Grade Level' or 'ObjectivesBox' content control in the table concerned - provided it's not showing the placeholder text.

Note: Because you have more content controls below whatever will be the final 'ObjectivesBox' content control, it was necessary to split that table in two. That shouldn't affect the functionality, however.

Thank you!!!!! That's super helpful!!! The pop-up to add another line is great!

After some conversation with my admin today.... there have been changes to the requirements for lesson plans... and some changes to the terminology being used. (For normal classrooms it isn't usually this convoluted... the challenge is when trying to make ESE classrooms like mine fit into the rigid system used by general ed classes.)

I've attached the (hopefully) last revision needed - shifting the names of our two existing drop-downs and adding a new column with a new drop-down in between the existing two, fed by a 2nd workbook. I've improved the original workbook so I included that too.

The names of the drop downs are: ProgramGoals, GiftedObjective, GiftedStandard

I tried going in and altering the code/program based on what I could figure out, but that didn't work. There is more finesse to it than I can pick up for studying the sample - although I certainly know more now than I did before!

Than you so, so much for your help.
This is going to be wonderful!!!!!

dede
Attached Files
File Type: dotm Lesson Plan Template Master D.dotm (53.0 KB, 33 views)
File Type: xlsx Master List of I Can Statements.xlsx (20.7 KB, 43 views)
File Type: xlsx Master List of Program Goals and Objectives.xlsx (15.6 KB, 46 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
excel formula while using dropdowns rjf1127 Excel 12 01-25-2017 10:53 AM
Populate Content Control Dropdowns from Excel 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
Populate Content Control Dropdowns from Excel Deleting a table from a content control -- preserving the content control BrainSlugs83 Word Tables 8 11-14-2013 03:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft