Using an Excel Spreadsheet to Populate a Combo Box

M

Missy Mason

Hi,

I am trying to use an Excel spreadsheet to populate a combo box. I have
created the combo box, but cannot figure out the syntax of how to type the
filename, path, and range into the rowsource property. Any help would be
greatly appreciated.

Regards,
 
J

Jonathan West

Hi Missy,

This group deals with VBA in Word. Are you working in Excel, or are you
working in Word and wanting to extract the information from the Excel
spreadsheet by setting up a connection to Excel?

If you are working in Excel, then you would be better off re-posting the
question to microsoft.public.excel.programming, where the Excel VBA experts
hang out.

If you are working in Word, then the RowSource propery does nothing in Word
and cannot be used, and you will have to use another way of populating the
combobox.

--
Regards
Jonathan West - Word MVP
MultiLinker - Automated generation of hyperlinks in Word
Conversion to PDF & HTML
http://www.multilinker.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Combo box 0
Mail Merge Directory Conditional Page Break 0
Integrating information from Word to Excel (not mail merge) 1
Populating a Combo Box with an Excel Row Source 1
Word macro that can call cells out of Excel for a find and replace 0
combo box 2
Using Office Forms and dynamically updating the excel backend 0

Top