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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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