Thread: [Solved] Dropdown Menu Dependent on a Previous Drop Down
View Single Post
 
Old 12-14-2018, 05:14 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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