Forum Discussion

RobertOliverNZ's avatar
RobertOliverNZ
Copper Contributor
May 23, 2023

Use "Value" Field from Drop-Down List Properties with a Combo Box Content Control

Hi There,   I am wanting to do something which should seem to be very basic but doesn't seem to work and am pulling my hair out. I am using a Combo Box Content Control drop down for users to select...
briannabang's avatar
briannabang
Copper Contributor
Dec 07, 2023
Hello - I need help with the same thing, however, my display names are different locations and the value needs to be their addresses. Can you help with this?
Doug_Robbins_Word_MVP's avatar
Doug_Robbins_Word_MVP
MVP
Dec 07, 2023

briannabang Assuming that you are using Content Controls as was originally the case in this thread, you will need to use the ContentControlOnExit property to get hold of the item selected from the dropdown list and then by reference to a source where you have the corresponding addresses obtain the address for insertion in the required location.  

 

If you are not fixed on using Content Controls, it can be better to make use of a UserForm.

See the following pages of Greg Maxey's website :

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

Resources