Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-13-2018, 08:06 PM
lgsikaffy lgsikaffy is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2018
Posts: 2
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

See, for example:
http://www.msofficeforums.com/word-v...html#post77762
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-14-2018, 04:45 PM
lgsikaffy lgsikaffy is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2018
Posts: 2
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Content Controls - Dependent Dropdown someazguy Word VBA 12 04-04-2018 05:29 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


All times are GMT -7. The time now is 02:23 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft