Populating a Combo Box with an Excel Row Source

[Missy Mason]

Hi,

I am trying to use an Excel spreadsheet to populate my combo box. The
problem I'm encountering is the syntax of the filename, path, and range for
the RowSource property. Any help would be greatly appreciated.

Regards

 

[Doug Robbins - Word MVP]

Hi Missy,

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

http://www.mvps.org/word/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