View Single Post
 
Old 11-01-2022, 08:59 PM
CellCharger CellCharger is offline Windows 10 Office 2019
Novice
 
Join Date: Oct 2021
Location: NJ, USA
Posts: 24
CellCharger is on a distinguished road
Default Create additional CCs based on Combo Box selection

Hi everyone,

I am not knowledgeable in VBA. I have a protected form with multiple Content Controls. One of which is a Combo Box.
Based on the Combo Box selection "C", I want the form to create two fields (Rich Text CC and Combo Box (with 3 selections: ACC, Ambient and Long-term), plus a text representing the fields' title).

To provide a visual, the form looks like the image to the left.
There are 3 empty cells where I need the additional CCs to be created in the area circled in red.
Once the user selects C from the "Protocol Type" Combo Box, 2 additional CC will be created. So basically, the form would look like the image to the right.



Something else I need to mention is that there is an existing macro in the form.

I tried to be as clear and descriptive as possible but please let me know if need to clarify anything else. I also attached the form.
Attached Images
File Type: png before.png (17.6 KB, 16 views)
File Type: png After.png (21.4 KB, 15 views)
Attached Files
File Type: docm Test form new macro enabled.docm (91.0 KB, 8 views)

Last edited by CellCharger; 11-02-2022 at 10:14 AM.
Reply With Quote