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: https://youtu.be/1Iw2-t8xNaQ 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: https://youtu.be/YktZ3B-tyqs
**BE SURE TO WATCH FILLABLE FORMS VIDEO PART 2: https://youtu.be/n_Ni_fj-158
__________
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.
__________
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
__________
NOTE: If you found this content helpful, please consider donating to my channel 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!
__________
RESOURCES & GEAR:
✦ Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
✦ Green Screen: https://amzn.to/2DnHsY2
✦ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog

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: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

Видео Create Multiple Level Dependent Drop-Down Lists in Word - Fillable Forms with 3 Cascading Levels канала Sharon Smith