Drop-down list populated with linked Excel column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Garrett - 16 May 2004 19:57 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 17 May 2004 04:09 GMT

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

http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm

Signature

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

> I'm trying to create a drop-down list in Word 2003 with a
> column of data in an Excel worksheet.
[quoted text clipped - 6 lines]
> once I inster the linked Excel object I get just an empty
> shaded field in the Word document. What am I missing?

Reply to this Message