+ Reply to Thread
Results 1 to 3 of 3

How can I add multiple items to Word drop downs without keying each item in?

  1. #1
    Registered User
    Join Date
    06-05-2018
    Location
    Washington D.C.
    MS-Off Ver
    2016
    Posts
    1

    How can I add multiple items to Word drop downs without keying each item in?

    Hello!

    So my goal is to enter as many names as I want at once into the Word drop downs created in the Design Mode under the Developer tab. As it is currently, you can only enter one name at a time. I have over 300 names I need to add to multiple drop downs on multiple documents so I have looked for a Macro solution.

    I found this solution here with the following code:

    Please Login or Register  to view this content.
    When I first used this I didn't realize I had to title the drop down with "DDList" (or whatever I want to call it; I have different name lists for different drop downs so I assume I can make a bunch of different ones with different names). Anyway, after doing that I was able to run the macro successfully and I was ecstatic. However after trying to run it on multiple drop downs at once it doesn't work. I asked the creator of the code if there was something wrong or if there was a work around I can do and he replied:

    "The code works with the first titled “DDList” If you have more than one titled DDList then you would have to used .Item(2), .Item(3) etc. Or if your CCs have different titles then change “DDList” in code above to the appropriate title as you process each one."

    I have no idea what this means or how I can use it to do what I want it to do. I am brand new to VBA's/Macros, I didn't even know they existed until this. Luckily google exists but I still can't seem to figure out what he means and what I should do to solve my problem. I'm hoping you guys can help me.

    Some side notes: I'm using Word 2016 on Windows 10

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: How can I add multiple items to Word drop downs without keying each item in?

    See, for example: http://www.msofficeforums.com/word-v...html#post46287
    The solution there uses an Excel workbook that holds the list.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: How can I add multiple items to Word drop downs without keying each item in?

    Cross-posted at: http://www.vbaexpress.com/forum/show...g-each-item-in
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multiple Drop Downs
    By wil79 in forum Excel General
    Replies: 3
    Last Post: 12-11-2017, 10:47 AM
  2. Clearing multiple dependent drop downs.
    By CustardSquare in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2014, 09:49 PM
  3. [SOLVED] Multiple drop downs
    By Treecko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-30-2013, 07:24 PM
  4. [SOLVED] I want to make a packing slip with macro enabled drop downs in the Item # column.
    By Legend Rubber in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 10-10-2012, 10:18 AM
  5. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 PM
  6. Multiple dependant drop downs
    By paconovellino in forum Excel General
    Replies: 11
    Last Post: 05-02-2012, 05:05 PM
  7. Replies: 4
    Last Post: 10-15-2008, 10:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1