If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drop-down list populated with linked Excel column
I'm trying to create a drop-down list in Word 2003 with a
column of data in an Excel worksheet. I can create a drop-down list but can only see how to populate it manually. Is it possible for to populate the drop-down list from an Excel worksheet? The help files seem to explain that this is possbile, but once I inster the linked Excel object I get just an empty shaded field in the Word document. What am I missing? |
#2
|
|||
|
|||
Drop-down list populated with linked Excel column
See the article "Load a ListBox from a Named Range in Excel using DAO" at:
http://word.mvps.org/FAQs/InterDev/F...xFromXLDAO.htm -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "Garrett" wrote in message ... I'm trying to create a drop-down list in Word 2003 with a column of data in an Excel worksheet. I can create a drop-down list but can only see how to populate it manually. Is it possible for to populate the drop-down list from an Excel worksheet? The help files seem to explain that this is possbile, but once I inster the linked Excel object I get just an empty shaded field in the Word document. What am I missing? |
Thread Tools | |
Display Modes | |
|
|