Populate Word Combo Box from Excel

[Steve C]

I'm building a user form in Word 2003. I want to populate a combo box with
company name values from an Excel spreadsheet. The spreadsheet also contains
address and other info as well, and is updated frequently. The ultimate goal
is that when the user chooses the company name, other text fields in the form
populate with the correct address, etc.

I need some help building the code that tells Word where the Excel file is,
what column to pull the company name from and makes sure it adapts to a
changing number of records. Any help with getting this portion of the code
started would be greatly appreciated!

 

[Doug Robbins - Word MVP on news.microsoft.com]

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

and the following pages of fellow MVP Greg Maxey's website :

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[Steve C]

Thanks for the links, Doug. They should help a lot!