Solved

Drop-Down List vs. VBA Macro - Microsoft Word

Posted on 2013-06-18
3
676 Views
Last Modified: 2013-06-26
I have a MS Word 2003 document that I want to insert drop-down menus into -  I can't password protect because the document needs to remain complete flexible (the 'free form text" fields used with the "form" function is too limiting for our users). Is there any way to insert drop-down menus without password-protecting/locking the document?

If there isn't, is there a simple VBA macro that I can use to create a drop-down menu (with as little as 2 options, and as many as 65 options) in a basic word document?
0
Comment
Question by:John_W_Cooney
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 39256830
You have several options.

1. You can use one or more Form Fields, and put them in a protected Section or Sections while leaving other sections editable. The advantage of this is that it requires no programming. The disadvantage is that the dropdown can only hold 25 items, and you lose spell checking facility for the whole document.

2. You can upgrade to a later Word version and use Content Controls

All the rest requires a knowledge of VBA

3. You can put an Active X control on the document. These may not be suitable to your task and are resource-hungry. See this article by Cindy Meister:
http://msdn.microsoft.com/en-us/library/office/aa140269%28v=office.10%29.aspx

4. It is possible to create a dropdown in a menu toolbar and select from that.

5. A VBA userform can have a Listbox or a Combo Box that can be used to hold items for selection
0
 

Author Comment

by:John_W_Cooney
ID: 39266812
Thank you for your response, but I’m not sure we’ll be able to use any of the options.
Some of our drop-downs have way more than 25 items
We’re unable to upgrade to a different version of Word (we’re using business software)
We don’t have knowledge of VBA, and are concerned that it would take time to create and to maintain.

Our document has to remain mostly a basic word document, so users can change headings, add formatting, attachments, etc. as they like – out of 15 pages, there are only about 10-15 drop-down lists that we need.  Is there any other method/tool out there (maybe that works as an add-on to Word) that we can use?
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 39276532
I'm not familiar with any such add-ins - my instinct is to do-it-myself.

It sounds like a fairly simple task. You could consider a bespoke solution. Some experts here will take on that sort of thing for payment. As individuals we are not permitted to solicit for such work, but any experts who do will have direct contact details in their profiles.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is a feature provided by MS Word that lets you create an Table of Contents for your Word document automatically. To use this feature for other documents there are two steps involved,   1.  Prepare your document for a table of contents (he…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
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 …
Suggested Courses

734 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