Solved

Drop-Down List vs. VBA Macro - Microsoft Word

Posted on 2013-06-18
3
664 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
  • 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Like many others, we try and discourage users from printing documents unnecessarily and instead send or share them electronically. However, this doesn't always work and documents are still printed. With this simple solution, if the user tries to …
Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

828 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