Multiple entries in dropdown lists

macropod · #1 04-02-2013, 08:16 PM

You could add the entries to a dropdown content control. As the dropdown only supports a single line per entry, the other data could be output to a plain text or rich text content control via an on_exit macro (i.e. you must exit the dropdown content control after updating it for the conditional output to appear). See attached demo. If you examine the dropdown, you'll see the Client names appear. And, if you examine the dropdown's properties, you'll see that for each client name, the 'Value' field contains the dependent data, with the different output lines separated by | characters, as in:
Phone: 08 1111 1111|Fax: 08 2222 2222|Email: sales@roundhousenurseries.com.au
The code is:

Code:

Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)
Dim i As Long, StrDetails As String
With ContentControl
  If .Title = "Client" Then
  For i = 1 To .DropdownListEntries.Count
    If .DropdownListEntries(i).Text = .Range.Text Then
      StrDetails = Replace(.DropdownListEntries(i).Value, "|", Chr(11))
      Exit For
    End If
  Next
  ActiveDocument.ContentControls(2).Range.Text = StrDetails
  End If
End With
End Sub

To access the macro in the attached document, open it and press Alt-F11.

rich_cirillo · #2 04-02-2013, 08:42 PM

That looks interesting...i could maybe used this for my needs

Rich

paul_pearson · #3 04-02-2013, 09:48 PM

Hi Paul
Looks excellent...i will have a play around later but so far looks great..
Is there a limit on how many entries i can place in the Content Control Dropdown box
If i want to add other lists further down the page such as personal information will i just use the code you supplied or will a further code update be required
Example:
Names: xxxxxxxxxxxx
Credit Card No: xxxxxxxxx
Card type: xxxxxxxxxx
Expiry date: xxxxxxxxxx
Thanks
Paul

macropod · #4 04-02-2013, 11:02 PM

Quote:

Originally Posted by paul_pearson

Is there a limit on how many entries i can place in the Content Control Dropdown box
If i want to add other lists further down the page such as personal information will i just use the code you supplied or will a further code update be required

I recently set up a process for someone who wanted to add 600 entries to one. Is that enough?

You won't need to make any code changes. Simply add your entries with the names as the content control display name and the other details with pipe separators (ie |) for each line as the content control value. It doesn't even matter if the number of lines vary from one client to the next.

paul_pearson · #5 04-02-2013, 11:12 PM

Hi Paul

Thank you

I think i will have 50

If you have time could you please attach a sample of the "other details with pipe separators (ie |) for each line as the content control value. It doesn't even matter if the number of lines vary from one client to the next"

Would be appreciated

Paul

macropod · #6 04-02-2013, 11:18 PM

Quote:

Originally Posted by paul_pearson

If you have time could you please attach a sample of the "other details with pipe separators (ie |) for each line as the content control value. It doesn't even matter if the number of lines vary from one client to the next"

You can already see the use of the pipe separators in the example I posted. Simply click on the content control, choose 'properties' (from the Ribbon's Developer tab), then select one of the entries and choose 'Modify'. If you add another pipe separator, plus some text, or delete everything from the existing last pipie separator onwards, you'll end up with a difference in the number of output lines for the two records you now have.

Dludwikowski · #7 03-12-2014, 08:35 AM

Quote:

Originally Posted by macropod

You could add the entries to a dropdown content control. As the dropdown only supports a single line per entry, the other data could be output to a plain text or rich text content control via an on_exit macro. See attached demo

Exactly what I want to do as well. Is it possible to do it for multiple content box dropdowns? I have a few different drop down fields that I want to change to the 'value', but when I test it out, it keeps only changing the first one.

Thanks!

cole.snavely · #8 08-24-2015, 01:10 PM

Would you be willing to discuss this in more detail with me? Your template is great, just not sure how to edit it to work with my stuff. Thanks so much!

ceeaye · #9 02-24-2017, 08:59 AM

Quote:

Originally Posted by macropod

You could add the entries to a dropdown content control. As the dropdown only supports a single line per entry, the other data could be output to a plain text or rich text content control via an on_exit macro. See attached demo

Hi there,

Ive attempted to utilize your demo and am having an issue with a new drop down box being added to the doc...

i have a dropdown cc named "Type" with a few choices within. I copied and pasted the dropdown cc onto the second page.

What happens is, my macro runs, the value changes per the macro; however, the first dropdon cc is not changed, the second is changed and a third dropdown cc magically appears.

Perhaps you can assist me with solving my issues? Please let me know.

Many thanks

tostrand · #10 07-12-2018, 08:06 AM

Quote:

Originally Posted by macropod

You could add the entries to a dropdown content control. As the dropdown only supports a single line per entry, the other data could be output to a plain text or rich text content control via an on_exit macro. See attached demo

I have opened this document and for some reason it doesn't give the information in the second content control. Does it work differently in Word 2016?

We have a form where we want the following:

If "To be processed" is selected in the dropdown list it should on a line below give information "We are including X amount of attachments" where X need to be a textbox.

Since this all is in a form.

Is this possible?

Many thanks

Tanja

tripster23 · #11 10-07-2020, 08:57 PM

Hi,

Thank you for this code. In the Content Control Properties > Drop-Down List Properties, is it possible to input more text? The Value field cuts off my text after a certain character limit.

bil_san1 · #12 10-11-2022, 02:47 PM

Hi,

I am new to Macros.. I was able to change the drop down items to and its result.

But I would like to change the First Content Control titles from "Client Details" to "Please Select" and the second Content Control Title from "Client" to "Blank"

I have tried to change in the properties and in the code too but it gives me

Run Time Error "6189"

Also I would like to result to be in other place not close to drop down menu.

Is it possible.

Thanks

macropod · #13 10-11-2022, 03:13 PM

Quote:

Originally Posted by bil_san1

But I would like to change the First Content Control titles from "Client Details" to "Please Select" and the second Content Control Title from "Client" to "Blank"

I have tried to change in the properties and in the code too but it gives me

Run Time Error "6189"

You need to change the titles in both the document and the code.

Quote:

Originally Posted by bil_san1

Also I would like to result to be in other place not close to drop down menu.

The output content control can be located anywhere in the document. If you want different parts of the output going to different content controls, see, for example, post #33 in this thread: https://www.msofficeforums.com/word-...html#post90264.

bil_san1 · #14 10-11-2022, 03:39 PM

Quote:

Originally Posted by macropod

You need to change the titles in both the document and the code.

I have changed in both code and properties box of both content control. It gives me an error when I click out of it. I have attached the file. Kindly have a look and guide me where I am making mistake.

The output content control can be located anywhere in the document. If you want different parts of the output going to different content controls, see, for example, post #33 in this thread: https://www.msofficeforums.com/word-...html#post90264.

I just want the complete result after a break of 1 or two lines.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete Multiple Entries	dudeabides	Office	1	07-04-2011 02:49 AM
Multiple task lists and multiple calendars	kballing	Outlook	0	01-18-2011 10:23 AM
Creating Multiple Contact Lists	meltee78	Outlook	1	01-03-2011 09:45 PM
multiple calendar entries across a group	halfhearted	Outlook	0	10-11-2009 12:13 PM
Word Forms : Dropdown lists	wferaera45	Word	0	04-06-2006 03:02 AM