Cascading Dependent Dropdowns with repeating content

[UQM]

I am attempting to make an audit tool for a pretty lengthy and detailed assessment. The assessment has 16 sections (A-G) and each section is comprised of numerous items. The auditor needs to be able to document the item that is incorrect, which portion of that item, the incorrect response, the correct response and the reason why. I know this audit tool with be pretty complicated with a significant amount of coding. I have played around with some dependent dropdowns and have gotten them working however this is only for one item in a section. Ideally, I would like to program in every single item and its potential responses to allow the auditor to document their findings quickly and efficiently.



I have attached the previous auditing document (Audit Tool) which required an extensive amount of free text to document an issues found; as well as the start of my vba coding (Audit VBA Coding) and the actual document I am creating. I have kept them separate at this time so I can simultaneously work on the coding and the formatting without having an issue with the design of one affect the other. I attempted to code based on Section G of the assessment since it has a number of options all variations of the 14 items may potentially need to be documented.

I was following the Sample B from this post https://www.msofficeforums.com/132696-post12.html

Actual Document: Loading Google Docs


Any insight would be greatly appreciated!

[gmayor]

You may find Content Control ADCAP (Advanced Capability) Dropdowns helpful