Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-12-2020, 05:51 PM
Guessed's Avatar
Guessed Guessed is offline Help with Drop Down Windows 10 Help with Drop Down Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

There is a non-macro way of doing this by using linked Content Controls. For the simplest example of this, I will choose to link to a built-in xml property.

First go to the Developer Tab and click on the XML Mapping Pane
Put your cursor where the dropdown list needs to appear. In the XML Mapping Pane, right click on one of the xml fields (I chose Category) and choose Insert Content Control > Dropdown List
Now move your cursor to where the employee number should appear. In the XML Mapping Pane, right click on the same xml field and choose Insert Content Control > Plain Text.
Now select the Dropdown List Content Control you added and go to Developer > Properties. Add the names and numbers by using the Add button (put employee names in the Display name field and their employee number in the Value field.

Once this is done, make a selection on the dropdown and the plain text content control will show the value.
Attached Images
File Type: png InsertLinkedCC.png (21.5 KB, 76 views)
File Type: png InsertLinkedCC_2.png (25.7 KB, 73 views)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 

Tags
design, drop down, drop down list



Similar Threads
Thread Thread Starter Forum Replies Last Post
Activate (show) a Drop-down form field when another drop-down form field is selected from Jentis Word VBA 1 04-19-2018 09:42 PM
Drop down box list based on response to another drop down box Phideaux Excel 16 04-13-2018 03:07 AM
Help with Drop Down Drop down lists and pulling data from worksheet based on drop down selection cjoyce73 Excel 5 07-17-2017 07:40 AM
Help, auto select drop down by another drop down value? skrallemand Word VBA 3 09-11-2013 11:55 AM
drop down box dockta Word 1 03-25-2013 10:12 PM

Other Forums: Access Forums

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