Create Multiple Level Dependent Drop-Down Lists in Word - Fillable Forms with 3 Cascading Levels

CREATE MULTIPLE LEVEL DEPENDENT DROP-DOWN LISTS IN WORD - HOW TO MAKE 2ND AND 3RD LEVEL CASCADING DROP-DOWN LISTS // Cascading drop-down lists allow you to create forms that help your users fill out forms faster and more accurately. This video shows you how to create a parent question that will drive the answer options on the child question and then that will drive the answer options on the grandchild question (so a 1st, 2nd and 3rd level of dependent drop-downs).

Be sure to also watch my other video:    • Create Dependent Drop-Down List in Word - ...   HOW TO CREATE A DEPENDENT DROP-DOWN LIST IN MS WORD 365 - LEGACY TOOL DROP DOWN FORM FIELD WITH VISUAL BASIC CODE

**YOU WILL NEED TO SAVE YOUR DOCUMENT AS A "WORD MACRO-ENABLED DOCUMENT (.docm)"

No prior knowledge of Visual Basic code is needed. Simply watch this video and use the code, highlighted in the video, that is pasted below. Be sure to follow all the steps and instructions in the video so you'll know how to modify this code to fit your particular needs.

Here is the Visual Basic code used in the 1st module in this video. Remember to replace "ddState 2nd", "ddRegion1st" and anything in quotes with your own form field bookmark labels and drop-down list options respectively:

Sub PopulateddState2nd()
Select Case ActiveDocument.FormFields("ddRegion1st").Result
Case "North"
With ActiveDocument.FormFields("ddState2nd").DropDown.ListEntries
.Clear
.Add "Michigan"
.Add "Ohio"
End With
Case "South"
With ActiveDocument.FormFields("ddState2nd").DropDown.ListEntries
.Clear
.Add "Georgia"
.Add "Texas"
End With
Case "East"
With ActiveDocument.FormFields("ddState2nd").DropDown.ListEntries
.Clear
.Add "New York"
.Add "Maine"
End With
Case "West"
With ActiveDocument.FormFields("ddState2nd").DropDown.ListEntries
.Clear
.Add "California"
.Add "Oregon"
End With
End Select
End Sub

Now, here is the VBA code for the 2nd module. Use this as a model if you want to create a 4th level dependent drop-down:
Sub PopulateddCity3rd()
Select Case ActiveDocument.FormFields("ddState2nd").Result
Case "Michigan"
With ActiveDocument.FormFields("ddCity3rd").DropDown.ListEntries
.Clear
.Add "Lansing"
.Add "Detroit"
End With
Case "Ohio"
With ActiveDocument.FormFields("ddCity3rd").DropDown.ListEntries
.Clear
.Add "Columbus"
.Add "Cleveland"
End With
Case "Georgia"
With ActiveDocument.FormFields("ddCity3rd").DropDown.ListEntries
.Clear
.Add "Atlanta"
.Add "Savannah"
End With
Case "Texas"
With ActiveDocument.FormFields("ddCity3rd").DropDown.ListEntries
.Clear
.Add "Houston"
.Add "Dallas"
End With
Case "New York"
With ActiveDocument.FormFields("ddCity3rd").DropDown.ListEntries
.Clear
.Add "Queens"
.Add "Brooklyn"
End With
Case "Maine"
With ActiveDocument.FormFields("ddCity3rd").DropDown.ListEntries
.Clear
.Add "Augusta"
.Add "Portland"
End With
Case "California"
With ActiveDocument.FormFields("ddCity3rd").DropDown.ListEntries
.Clear
.Add "San Francisco"
.Add "San Diego"
End With
Case "Oregon"
With ActiveDocument.FormFields("ddCity3rd").DropDown.ListEntries
.Clear
.Add "Portland"
.Add "Salem"
End With
End Select
End Sub
_________
**BE SURE TO WATCH FILLABLE FORMS VIDEO PART 1:    • How To Create A Fillable Form In Microsoft...  
**BE SURE TO WATCH FILLABLE FORMS VIDEO PART 2:    • Make Fillable Forms in MS Word - Content C...  
__________
FREE DOWNLOADS:
✦ Visit https://mailchi.mp/6a0859ea0844/sharo... 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.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn:   / sharonsmithhr  
Twitter:   / sharonsmithhr  
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr.... 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!
__________
RESOURCES & GEAR:
✦ Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
✦ Green Screen: https://amzn.to/2DnHsY2
✦ JotForm: https://www.jotform.com/pricing/?utm_...

Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
KEYWORDS: #MSWord, microsoft word tutorial, multiple dependent drop down, multiple dependent drop down lists, parent child drop down relationship, multi level dependent dropdown, third level, dependent dropdown in word, cascading list box, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤Creating Fillable Forms:    • How To Create A Fillable Form In Microsoft...