MS Word 2007 drop-down boxes

I am trying to create a form that will contain drop-down boxes.

Questions:

1. Can i import the potential choices into the drop-down list? I really dont want to type 100+ entries
2. Once a selection is made e.g. customer name can the form "push" data to toher fields, e.g. customer #, sales person etc.

The start of my form is attached ee-sample.docx
hwassingerAsked:
Who is Participating?
 
dlc110161Connect With a Mentor Commented:
The type of drop down you are using is limited to 25 entries.

If you don't need more than 25 entries, then the attached code will work for you. Otherwise, attached is a document that uses a Form that can contain more than the 25 entries limit and the code necessary to populate it.

Dawn Bleuel
Word MVP
Sub PopulateDropDown()
'Dim strCoName As String
'strCoName = ActiveDocument.FormFields("CoName").DropDown.Value
If ActiveDocument.FormFields("CoName").DropDown.Value = 2 Then
With ActiveDocument.FormFields("Platform").DropDown.ListEntries
.Add Name:="Platform X"
.Add Name:="Platform Y"
End With
Else
With ActiveDocument.FormFields("Platform").DropDown.ListEntries
.Add Name:="Platform A"
.Add Name:="Platform B"
End With
End If
End Sub
Sub DeleteDropDown()
With ActiveDocument.FormFields("Platform").DropDown.ListEntries
.Clear
End With
End Sub

Open in new window

ComboBox.doc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.