Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-26-2021, 08:31 AM
daft21 daft21 is offline Creating an Auto-Generated Field dependent on Drop-Down List Windows 10 Creating an Auto-Generated Field dependent on Drop-Down List Office 2016
Novice
Creating an Auto-Generated Field dependent on Drop-Down List
 
Join Date: Jul 2021
Posts: 1
daft21 is on a distinguished road
Default Creating an Auto-Generated Field dependent on Drop-Down List

Hello Everyone!



I am working on a templates for my employer who wants me to make offer letters for a range of different positions and wanted to implement Drop-Down Lists and Content Controls to make it so that I can have 1 template that covers multiple positions in our company.

I have learned about Drop-Down lists (From the developer ribbon tab) and I found a file example from the user 'MacroPod', under the thread provided in the link below, which helped me immensely in understanding what I was aiming to do.

Here is the thread, and the file in which an example was provided:
https://www.msofficeforums.com/word-...html#post46903

However, I am seeking assistance from anyone in regards to the following:

I want to have a drop-down list that has a list of specific job positions, and for each job position, I want it to auto generate a job description of that same position wherever it needs to be mentioned, along with bullets, bolding, and specific text font color.

I also want to mention that I am not familiar with how to use Macros, nor did I see or understand how 'MacroPod' made it so that their drop-down list 'values' appeared on another 'Content Controlled' box, per se, from the file provided in the thread that I linked above. So if someone can explain that to me, that would be immensely helpful.

Example of what I want:

If I select, from a drop-down list, a position called 'Project Coordinator', I want it to auto generate the following:

Roles & Responsibilities
  • Inputs new customer accounts; price lists ensuring the data is up to date
  • Establishes new resources with price lists ensuring the data is up to date
  • Answers phones and responds to client as well as resource requests and inquiries.

Required Qualifications
  • Associate Degree with 3-5 years of relevant experience, or a combination of education and experience
  • Proficiency with MS Office
  • Proven ability to multitask; meticulous attention to detail


And if I select another position, I would get a similar format, but with different Roles & Responsibilities and Required Qualifications.

I would greatly appreciate the assistance and instruction anyone can provide!
Attached Files
File Type: docm Content Controls - Dropdown Dependent Text.docm (36.6 KB, 9 views)
Reply With Quote
  #2  
Old 07-26-2021, 05:54 PM
Guessed's Avatar
Guessed Guessed is online now Creating an Auto-Generated Field dependent on Drop-Down List Windows 10 Creating an Auto-Generated Field dependent on Drop-Down List Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

IMHO, Macropod's post was aimed at a different requirement to what you describe.

I think you should be looking to store each role's info in a Building Block with the name of the role. And then create a Building Block Content Control to enable you to choose which one you want. If you've never used this type of CC before it can be useful to start by watching some youtube instructional videos. This one looks relevant TPPG Forms 06 Building Block Gallery Content Control - YouTube
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto populate building block autotext on dependent drop down exit jayevan4 Word VBA 7 05-21-2020 10:25 AM
Can a text form field be dependent on a drop-down? scannella Word 4 07-31-2019 03:36 PM
Creating an Auto-Generated Field dependent on Drop-Down List auto populate multiple text boxes dependent on a drop down angelaschultz Word VBA 7 03-18-2017 03:00 PM
Creating an Auto-Generated Field dependent on Drop-Down List Auto Populate Text On Dependent Drop Down Exit GregStewartPTC Word VBA 2 02-27-2017 05:37 AM
Help with Vlookup in a Dependent drop down list angelmr Excel 0 11-29-2016 09:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:18 PM.


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