Microsoft Office Forums Multiple dependent dropdown lists in table with add new row option

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2019, 08:25 AM
jeweldarby jeweldarby is offline Multiple dependent dropdown lists in table with add new row option Windows 8 Multiple dependent dropdown lists in table with add new row option Office 2010 32bit
Novice
Multiple dependent dropdown lists in table with add new row option
 
Join Date: Sep 2015
Posts: 5
jeweldarby is on a distinguished road
Default Multiple dependent dropdown lists in table with add new row option

I have a table with 2 pairs of dependent dropdown lists (DDLs) in the content controls (CCs).

I would like the user to select an an option from the 1st DDL, have the correct list of options in the 2nd DDL, then select an option from the 3rd DDL, and have the correct list of options in the 4th DDL. When the last CC in the row is exited, user would be prompted whether to add a new row.

Drawing from the following threads found here:
https://www.msofficeforums.com/word-...recursive.html
https://www.msofficeforums.com/word-...html#post38312



Attaching these files:
DependentDDL_Test1.docm -My test document with more description of the problem
doc1_v7 (1).docm - with code from recursive example thread
Content Controls - Table Row Add.docm - with code from add row thread

Thanks in advance for any help you can provide.
Attached Files
File Type: docm DependentDDL_Test1.docm (50.1 KB, 2 views)
File Type: docm doc1_v7 (1).docm (34.1 KB, 0 views)
File Type: docm Content Controls - Table Row Add.docm (39.9 KB, 0 views)

Last edited by jeweldarby; 10-13-2019 at 08:26 AM. Reason: fix typos
Reply With Quote
  #2  
Old 10-13-2019, 08:59 PM
macropod's Avatar
macropod macropod is offline Multiple dependent dropdown lists in table with add new row option Windows 7 64bit Multiple dependent dropdown lists in table with add new row option Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,657
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You don't say what aspects you need help with. That said, see:

Dependent Dropdown Content Controls
Help with cascading dropdown list

Hierarchical Dropdown Content Controls
Creating a reducing drop down list
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 10-14-2019, 03:43 AM
jeweldarby jeweldarby is offline Multiple dependent dropdown lists in table with add new row option Windows 8 Multiple dependent dropdown lists in table with add new row option Office 2010 32bit
Novice
Multiple dependent dropdown lists in table with add new row option
 
Join Date: Sep 2015
Posts: 5
jeweldarby is on a distinguished road
Default

I need help integrating the two referenced solutions into one Document_ContentControlOnExit event to update the dependent DDLs and to add the a new row option that updates the CC Tags to pair them.


See additional information in the DependentDDL_Test1 document. Thanks
Reply With Quote
  #4  
Old 10-14-2019, 10:05 PM
macropod's Avatar
macropod macropod is offline Multiple dependent dropdown lists in table with add new row option Windows 7 64bit Multiple dependent dropdown lists in table with add new row option Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,657
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Try the attached.
Attached Files
File Type: docm DependentDDL_Test.docm (56.7 KB, 5 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 10-15-2019, 06:53 AM
jeweldarby jeweldarby is offline Multiple dependent dropdown lists in table with add new row option Windows 8 Multiple dependent dropdown lists in table with add new row option Office 2010 32bit
Novice
Multiple dependent dropdown lists in table with add new row option
 
Join Date: Sep 2015
Posts: 5
jeweldarby is on a distinguished road
Default

Many thanks Macropod. This works great. Thanks for your speedy response, too.
Reply With Quote
Reply

Tags
content controls, dependent dropdown list, word vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple dependent dropdown lists in table with add new row option Multiple entries in dropdown lists paul_pearson Word VBA 128 11-12-2019 03:10 PM
Muliple entries in Multiple dropdown lists Haygordon Word VBA 7 04-04-2019 06:28 AM
Multiple dependent dropdown lists in table with add new row option Dropdown Menu Dependent on a Previous Drop Down lgsikaffy Word VBA 3 12-14-2018 05:14 PM
Multiple dependent dropdown lists in table with add new row option Content Controls - Dependent Dropdown someazguy Word VBA 12 04-04-2018 05:29 PM
Dropdown dependent text JakeLRL Word VBA 7 04-07-2016 08:26 AM


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


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