View Single Post
 
Old 07-07-2016, 11:00 PM
celias celias is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2016
Posts: 5
celias is on a distinguished road
Question Having a Drop-down list in Word referring to an Excel list

Hello, brilliant people!
I wonder if this can be done:

I have a Word Template Document with several fields. In one of them, I want to have a drop-down list whose items are on an Excel File called "ClientList" - in Sheet1, column A. This list has more than 100 items.

Is it possible to automatically refer this drop-down list to that Excel list so that it is always updated, meaning that if any changes are made to the Excel file, the next time I open the Word template document, the list is complete and up-to-date?

I know very little of Macros and VBA but I am willing to learn. If this is something that you think you could teach me how to do, please remember that I am a newbie.

Thank you very much in advance for any help provided.
Reply With Quote