MS Word Drop-Down list linked to outside source?
in [Document Management]
|
Prev: How do I enter the product key after installation completed?
Next: keeping footnotes on same page using Microsoft Word 2007
From: Yotafan on 1 Feb 2010 09:58 I was wondering if it is possible to link a word drop down list to an outside source such as an Excel list or and Access table. My Scenario: I have created 70+ locked templates that use some similiar drop down lists. These lists include Judges, Lawyers, and Arbitrators names that can change monthly. So i was looking for a better solution than me editing every drop down list on each template. I would like to be able to link a drop down list to say an MS Access table and so i can just edit the table and each drop down would just pull the info from that. Is this possible to do or is there a better solution? TIA Ed
From: Doug Robbins - Word MVP on 1 Feb 2010 21:45
See the article "How to create a Userform" at: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm and the following pages of fellow MVP Greg Maxey's website : http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Yotafan" <Yotafan(a)discussions.microsoft.com> wrote in message news:E4A3E034-C57A-4135-ABF7-5FB826A9E065(a)microsoft.com... >I was wondering if it is possible to link a word drop down list to an >outside > source such as an Excel list or and Access table. > > My Scenario: > I have created 70+ locked templates that use some similiar drop down > lists. > These lists include Judges, Lawyers, and Arbitrators names that can change > monthly. So i was looking for a better solution than me editing every > drop > down list on each template. > > > I would like to be able to link a drop down list to say an MS Access table > and so i can just edit the table and each drop down would just pull the > info > from that. > > Is this possible to do or is there a better solution? > TIA > > Ed |