Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 12-14-2018, 05:14 PM
macropod's Avatar
macropod macropod is offline Dropdown Menu Dependent on a Previous Drop Down Windows 7 64bit Dropdown Menu Dependent on a Previous Drop Down Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In the document attached to the link, you'll see two dropdowns: a 'master'; and a 'slave'. If you press Alt-F11, that will open the VBA editor where you'll see the code that drives the process. When implementing this in your form, you can change the:
• content control titles - provided you update the VBA code references to match;
• the selection options for the 'master' control (both in the document and in the VBA code); and
• dependent outputs defined for the 'slave' control via the Select Case statement in the VBA code.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dropdown Menu Dependent on a Previous Drop Down Content Controls - Dependent Dropdown someazguy Word VBA 14 02-05-2023 08:01 PM
Dropdown dependent text JakeLRL Word VBA 7 04-07-2016 08:26 AM
make text form field active dependent on dropdown Glenn0004 Word VBA 1 06-23-2015 06:13 PM
Dependent drop down lists bobbych Word 1 02-08-2013 04:38 PM
How to create a Dependent Drop-Down Picklist ComcoDG Word 2 03-17-2009 07:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:46 PM.


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