View Single Post
 
Old 04-02-2016, 07:58 AM
jsperry jsperry is offline Mac OS X Office 2007
Novice
 
Join Date: Apr 2016
Posts: 1
jsperry is on a distinguished road
Question Multiple Dependant Drop Down Fields

I am so new to VBA Codes, I am not even considered a newbie!
I am looking to create a Word Document that has 3 dependent drop down fields.

Example.

First Drop Down should display a choice of : Outlet 1 or Outlet 2

Second Drop Down should display a list of department numbers based on which selection was chosen in the first drop down (ie. if they choose outlet 1, only code 010, 020, 030 show) If they choose outlet 2 then S010, S020, S030 should show)

Third Drop Down should display codes based on the results of the second drop down box. (Example. If you choose 020 then code 11112 should show, if you choose S020, then S41114 should show)

I see examples of coding on how to make 1 dropdown dependent on another but not how to make 2 fields dependent on each other. Is this possible? Can someone explain the how to in a extremely simple, basic way?

Thanks in advance!
Reply With Quote