![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
I'm assuming this is a simple one, but its one of those days where I am banging my head against the wall. I'm more used to building stuff in power apps, and it spoon feeding me a lot of things so I am not as familiar with the VBA in words and what the items are called and I have available
right so what I am trying to do is this. I have a named Dropdown control called ROLE, within it there are 4 options a user can select. lets call them a,b,c,d and dependant on which one they select i want it to toggle a number (8) of check boxes on or off. Its not a simple if a then cb1 & 2 are set to true, as some of the check boxes will be true for more than one of the drop down option. Im assuming I need to run it as an If/else similar to this Code:
If ddbox.ROLE.title = "a" Then cb1 = "True" cb2 = "True" Cb4= "True" ElseIf ddbox.ROLE.title = "b" Then cb1 = "True" cb4 = "True" Cb5= "True" ElseIf ddbox.ROLE.title = "c" Then cb2 = "True" cb3 = "True" cb4= "True" cb6= "True" cb8= "True" ElseIf ddbox.ROL.title = "d" Then cb2 = "True" End If End Function |
Tags |
checkbox, office365 desktop, vba |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Assigning Values to content control checkboxes and calculating results | nuraish | Word Tables | 1 | 08-18-2021 03:14 AM |
Using Content Control Checkboxes to open associated excel files | shaztastic | Word VBA | 5 | 08-26-2018 07:13 AM |
![]() |
wlcdo2 | Word VBA | 3 | 01-05-2017 05:52 PM |
![]() |
DougsGraphics | Word VBA | 2 | 06-24-2015 07:31 AM |
![]() |
creative cathy | Word Tables | 13 | 10-07-2012 08:52 PM |