Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #19  
Old 09-05-2017, 06:49 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
Re: Network Location Issue & Sharing with Colleagues
If the template & workbook can be stored in the same folder, you (or I) could change this line in the code:
StrWkBkNm = "C:\Users\" & Environ("Username") & "\Documents\Master List of I Can Statements.xlsx"
to:
StrWkBkNm = "ThisDocument.Path & "\Master List of I Can Statements.xlsx"

That will address any Network Location & Sharing issues. Simply send colleagues both, with advice to keep them in the same folder.

To edit the template, simply use File|Open, choose the 'All Word templates' file type, then navigate to where your template is stored and select it.

Re: Number of Learning Target Lines & Number of Date & Grade Lines
Perhaps you could attach a document showing what you mean.

Re: Progress Description After I Can
Yes, that's possible, but it seems to me there is a more fundamental issue to be addressed: the standardisation of Progress Descriptors. In any event, if you distribute the workbook and don't protect it, anyone can change the Progress Descriptions there.
=============================================

Can I bother you to make that alteration so that the network issue goes away - so keeping both docs in one file will work?
Thank you.

Next, I've attached a new version of the lesson plan.

There are two cells - each with a green box with an arrow.
One at the end of the Date - Grade - Notes line.
The other at the end of the Gifted Domains - Gifted Standards line.

Is it possible to turn those two green cells into a "button" of some kind which, when clicked or selected, will create an additional row of cells beneath the existing row?

ideally, when making the lesson plan, I'll be able to click on the green arrow cell and another row will show up so I can select another Gifted Domain and Gifted Standard.

Is that possible?

Thanks,
dede
Attached Files
File Type: dotm Lesson Plan MASTER TEMPLATE C.dotm (55.4 KB, 19 views)
Reply With Quote
 



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 09:23 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