MS Word 2007 drop-down boxes

Posted on 2011-10-27
Last Modified: 2012-05-12
I am trying to create a form that will contain drop-down boxes.


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
Question by:hwassinger
    1 Comment
    LVL 19

    Accepted Solution

    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
    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
    End With
    End Sub

    Open in new window


    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing. A Range prope…
    I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
    This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now