Drop-down list populated with linked Excel column

[Garrett]

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?

 

[Doug Robbins - Word MVP]

See the article "Load a ListBox from a Named Range in Excel using DAO" at:

http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.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