Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2018, 08:06 PM
lgsikaffy lgsikaffy is offline Dropdown Menu Dependent on a Previous Drop Down Windows 10 Dropdown Menu Dependent on a Previous Drop Down Office 2013
Novice
Dropdown Menu Dependent on a Previous Drop Down
 
Join Date: Dec 2018
Posts: 6
lgsikaffy is on a distinguished road
Lightbulb Dropdown Menu Dependent on a Previous Drop Down

Hello,



I am attempting to standardize hiring documents for several countries and I'm trying to have a drop-down menu with each country listed that then auto-populates the correct identifications required for data entry.

I was thinking maybe having a drop-down dependent on a previous drop down?
Would this be the appropriate way to go about this or is there a better/more efficient way?

Can someone please advise on how to do this?
Thank you!
Reply With Quote
  #2  
Old 12-13-2018, 08:15 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: 21,962
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

See, for example:
https://www.msofficeforums.com/word-...html#post77762
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-14-2018, 04:45 PM
lgsikaffy lgsikaffy is offline Dropdown Menu Dependent on a Previous Drop Down Windows 10 Dropdown Menu Dependent on a Previous Drop Down Office 2013
Novice
Dropdown Menu Dependent on a Previous Drop Down
 
Join Date: Dec 2018
Posts: 6
lgsikaffy is on a distinguished road
Smile

Thank you so much Paul, I see that this has already been solved.
I am just starting with this VBA and I'm not sure of how to process that could you perhaps guide me or point me into the direction of something that can teach me how to enter that?

Please!
Thank you!
Reply With Quote
  #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: 21,962
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
Reply

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 05:28 PM.


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