Try the attached. Simply update the text content controls, then select the dropdown content control.

Attached Files

CCtrl DropDown Populate.zip (32.1 KB, 34 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you all for the replies! I will try these over the next couple of days and post results.

Hi
I would recommend you go with Paul's solution as it is more efficient.
Good luck.
Tony

This is exactly what I was looking for to use in Word. I cannot figure out how to modify the code to have multiples of these. Is that easy?

I will be using the other to use in Excel forms that I already have

Thanks again All

That depends on what you want to do - and how comptetent you are using content controls and vba.

For example, if you want to add another set to populate a different dropdown content control with the contents of another set of text content controls, it's quite easy to replicate the If ... End If block and change the content control titles to suit whatever you use for the parallel set.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for the reply...
unfortunately I am not very competent with vba. I tried to just copy/paste the code and change the titles(in bold from your code below) I am not sure what the lines below it are doing... I am trying to get some help internally but not much experience there either. I am not clear on what the lines in red are doing(which is most of the code)


If ContentControl.Title = "Period" Then
ContentControl.DropdownListEntries.Clear
For i = 1 To .ContentControls.Count
If Left(.ContentControls(i).Title, 4) = "Time" Then
j = j + 1
ContentControl.DropdownListEntries.Add Text:=j & " - " & .ContentControls(i).Range.Text