In Creating Fillable Forms in Word Lesson 7, we will create multiple levels of dependent drop-down lists. This is where a user selects an item from the 1st drop-down list and based on that selection, the items that appear available in the 2nd drop-down are dependent on the first selection, and then based on the 2nd selection, a 3rd drop-down displays a filtered list that is dependent on the 2nd field selection. In our form example, we have a Location field that will drive what displays as selections in the Department field and that will drive which Managers a user can choose from. You will need to save your document as a Macro Enabled document to use this functionality. To program this, we will use the VB Code below.
Module 1
Sub PopulateddDepartment2nd()
Select Case ActiveDocument.FormFields(“ddLocation1st”).Result
Case “Home Office”
With ActiveDocument.FormFields(“ddDepartment2nd”).DropDown.ListEntries
.Clear
.Add “Sales”
.Add “Finance”
.Add “Operations”
End With
Case “Satellite Office”
With ActiveDocument.FormFields(“ddDepartment2nd”).DropDown.ListEntries
.Clear
.Add “Human Resources”
.Add “Information Technology”
.Add “Marketing”
End With
End Select
End Sub
Module 2
Sub PopulateddManager3rd()
Select Case ActiveDocument.FormFields(“ddDepartment2nd”).Result
Case “Sales”
With ActiveDocument.FormFields(“ddManager3rd”).DropDown.ListEntries
.Clear
.Add “Burton Guster”
.Add “Doug Heffernan”
End With
Case “Finance”
With ActiveDocument.FormFields(“ddManager3rd”).DropDown.ListEntries
.Clear
.Add “Jeff Bingham”
.Add “Samantha LaRusso”
End With
Case “Operations”
With ActiveDocument.FormFields(“ddManager3rd”).DropDown.ListEntries
.Clear
.Add “Russell Dunbar”
.Add “Shawn Spencer”
End With
Case “Human Resources”
With ActiveDocument.FormFields(“ddManager3rd”).DropDown.ListEntries
.Clear
.Add “Buffy Summers”
.Add “Juliette O’Hara”
End With
Case “Information Technology”
With ActiveDocument.FormFields(“ddManager3rd”).DropDown.ListEntries
.Clear
.Add “Jen Barber”
.Add “Maurice Moss”
End With
Case “Marketing”
With ActiveDocument.FormFields(“ddManager3rd”).DropDown.ListEntries
.Clear
.Add “Kelly Palmer”
.Add “Chale Witt”
End With
End Select
End Sub
COURSE: Creating Fillable Forms in Microsoft Word – A Step-by-Step Guide
Introduction
Lesson 1: Microsoft Word Form Overview
Lesson 2: Form Field Types & Functionality
Lesson 3: Content Control Form Fields
Lesson 4: Legacy Form Fields
Lesson 5: Building a Form Template from Scratch
Lesson 6: Enforce Form Field Number Formatting
Lesson 7: Create Multiple Level Dependent Drop-Down Lists
Lesson 8: Make Form Fields Required
Lesson 9: Link Text to Drop-Down Selection
Lesson 10: Make Form Fields Repeat
Lesson 11: Calculating Form Fields
Lesson 12: Insert a Submit Button
Lesson 13: Lock Forms or Parts of Forms
Lesson 14: Test & Distribute your Form
Lesson 15: Gather & Analyze Results
Wrap-up Creating Fillable Forms in Word
__________
CONNECT WITH ME 📎
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
Instagram: https://www.instagram.com/sharonsmithlearn/
Facebook: https://www.facebook.com/profile.php?id=100090910316584
__________
TEMPLATES
Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/875846662/employee-engagement-survey-ms-excel?ref=listing_published_alert
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel, either by clicking the YouTube Super Thanks button under my videos, or from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS
✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
PLAYLISTS:
➤ Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD
➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv
➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45
➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90
➤PowerPoint Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM
➤ Excel Tips & Tricks (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW
source
como comprar um site , Create Multiple-Level Dependent Drop-Down Lists – Create Fillable Forms in Word Course Lesson 7
