• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

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
0
hwassinger
Asked:
hwassinger
1 Solution
 
dlc110161Commented:
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now