Quote:
Originally Posted by macropod
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.
|
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