Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-14-2024, 06:43 AM
ccamm ccamm is offline Toggling control checkboxes to true when a value in a control drop down is selected Windows 10 Toggling control checkboxes to true when a value in a control drop down is selected Office 2021
Novice
Toggling control checkboxes to true when a value in a control drop down is selected
 
Join Date: Mar 2024
Posts: 2
ccamm is on a distinguished road
Default Toggling control checkboxes to true when a value in a control drop down is selected

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
help please?
Reply With Quote
 

Tags
checkbox, office365 desktop, vba



Similar Threads
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
Toggling control checkboxes to true when a value in a control drop down is selected Content Control Checkboxes wlcdo2 Word VBA 3 01-05-2017 05:52 PM
Toggling control checkboxes to true when a value in a control drop down is selected Clicking the selected Content Control checkbox returns wrong control in vba event DougsGraphics Word VBA 2 06-24-2015 07:31 AM
Toggling control checkboxes to true when a value in a control drop down is selected Assigning Values to content control checkboxes and calculating results creative cathy Word Tables 13 10-07-2012 08:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:56 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