Add combobox to a Word doc and populate the combobox with list of about 65 items

[excelaron]

Hello, I'm having trouble with a combobox on a Word doc and populating with our company's school addresses (64 schools)
I'm new Word VBA (I'm an Excel guy). I would appreciate any help. It has to be done in Word.

[macropod]

What kind of combobox? A Useform Combobox or a Content Control combobox?

Populating these in Word is really no different to populating them in Excel. What code are you using? What specific problem are you having?

[excelaron]

I need a Content Control combobox hold company school addresses for a Word form for students to fill out for addmissions

[excelaron]

I have a list of about 65 schools, address, Phone. I just want the combobox to work just like a validation drop down in excel where I select list and =mylist.

Is there a way to input the all the school addresses from a excel range or a word table?

[macropod]

Here's how to do it from a list in a Word table:

Sub Demo()
Dim i As Long, Rng As Range
With ActiveDocument.Tables(1)
  For i = 1 To .Rows.Count
    Set Rng = .Rows(i).Range.Cells(1).Range
    Rng.End = Rng.End - 1
    If Trim(Rng.Text) <> "" Then
      ActiveDocument.ContentControls(1).DropdownListEntries.Add Text:=Rng.Text, Index:=i
    End If
  Next
End With
End Sub

You could do it from an Excel workbook but, apart from the necessary coding differences, that workbook would also have to be available to the students.

[excelaron]

Hello maropod, I sorry my boss is driving me cazy on this one. We already have a perfect Adobe form, but they want it in Word and we upload it to Sharepoint. So the data has to be in the Word doc I'm thinking. Right.

[excelaron]

Thanks for all your help, macropod