Microsoft Office Forums

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, 16 views)
File Type: docm doc1_v7 (1).docm (34.1 KB, 12 views)
File Type: docm Content Controls - Table Row Add.docm (39.9 KB, 13 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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr 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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the attached.
Attached Files
File Type: docm DependentDDL_Test.docm (44.2 KB, 21 views)
__________________
Cheers,
Paul Edstein
[Fmr 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
  #6  
Old 05-10-2022, 01:39 AM
solar94 solar94 is offline Multiple dependent dropdown lists in table with add new row option Windows 11 Multiple dependent dropdown lists in table with add new row option Office 2021
Novice
 
Join Date: May 2022
Posts: 2
solar94 is on a distinguished road
Default DependentDDL_Test

Quote:
Originally Posted by macropod View Post
Try the attached.
Bonjour

Je vous remercie par avance. J'ai utilisé votre fichier "DependentDDL_Test" pour mes propres besoins mais je bloque à la fin car j'ai adapté le fichier à mes besoins. Pourriez vous avoir la gentillesse de corriger mon problème ?

Très sincères salutations.
Quote:
Translation:
Hello

I thank you in advance. I used your file "DependentDDL_Test" for my own purposes but I get stuck at the end because I adapted the file to my needs. Could you be kind enough to correct my problem?

Very sincere greetings.
Attached Files
File Type: docm TRY_DependentDDL_Test.docm (42.3 KB, 8 views)
Reply With Quote
  #7  
Old 05-21-2022, 04:37 PM
macropod's Avatar
macropod macropod is offline Multiple dependent dropdown lists in table with add new row option Windows 10 Multiple dependent dropdown lists in table with add new row option Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It is not apparent o me what you are trying to do. The dependencies discussed in this thread concern dropdown content controls in columns 2 and 4 whose options depend on the selections in columns 1 and 3.

Did you check the links referred to on post #2?

Ce que vous essayez de faire ne m'apparaît pas. Les dépendances discutées dans ce fil concernent les contrôles de contenu déroulant dans les colonnes 2 et 4 dont les options dépendent des sélections dans les colonnes 1 et 3.

Avez-vous vérifié les liens mentionnés sur le post #2 ?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
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 151 10-18-2023 04:23 PM
Multiple dependent dropdown lists in table with add new row option Content Controls - Dependent Dropdown someazguy Word VBA 14 02-05-2023 08:01 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
Dropdown dependent text JakeLRL Word VBA 7 04-07-2016 08:26 AM

Other Forums: Access Forums

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


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