Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-01-2022, 08:59 PM
CellCharger CellCharger is offline Create additional CCs based on Combo Box selection Windows 10 Create additional CCs based on Combo Box selection Office 2019
Novice
Create additional CCs based on Combo Box selection
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Text based on selection of dropdown list cloud67 Word VBA 2 08-09-2019 06:46 AM
Reveal portion of document based on dropdown selection chappeja Word VBA 1 03-27-2019 08:36 PM
Create additional CCs based on Combo Box selection Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Alfred Mail Merge 2 05-23-2017 10:59 PM
text based on Combo box selection rosscortb Word VBA 3 03-16-2015 06:57 PM
Inserting a particular image based on a combobox selection LeonieD PowerPoint 2 06-27-2014 05:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:39 AM.


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