How to import list from Excel into drop-down list into word

gmaxey · #1 07-08-2016, 05:24 AM

If you are asking about:

Code:

Debug.Print Selection.Range.ContentControls(1).ID
'or
MsgBox Selection.Range.ContentControls(1).ID

You can run either from the VB Immediate window.

celias · #2 07-10-2016, 10:46 PM

Quote:

Originally Posted by gmaxey

I you are asking about:

Code:

Debug.Print Selection.Range.ContentControls(1).ID
'or
MsgBox Selection.Range.ContentControls(1).ID

You can run either from the VB Immediate window.

Hi, @gmaxey,
I was asking about the very first code on this thread (I'm sorry if I didn't place my question correctly).

I have a word template file with just one dropdown list created. I named the dropdown list as "Clients" and it has no options entered yet. I wanted to fill it with a list of clients that I have on column A of Sheet1 on an Excel file called "Clients List".

I created a macro on Word called Dropdownlist and I pasted the suggested code there. I changed the location for the StrWkBkNm file.

When I run the macro I get the error message: "Run-time error '1004': Application-defined or object-defined error". The file does exist and column A of sheet1 has data from A1 down to A106...

Do you have a suggestion about how to fix this?
Would this have to do with something called "declarations" that I saw somewhere?

Thank you in advance for any tip.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamically changing drop-down list based on selection? (Word Form)	laurarem	Word	1	02-21-2013 10:17 PM
How to import a list of names into PowerPoint from Excel?	CarpetRemnant	PowerPoint	4	12-07-2012 11:08 AM
Drop down list, Can it be done???	garethreid	Outlook	0	08-09-2012 06:08 AM
drop down list from external data source Excel 2007?	Intruder	Excel	1	08-03-2012 05:41 AM
Long List for drop down box	DLo99	Word	0	02-28-2010 08:07 AM