Take an Excel List and Add to Word Combo Box

macropod · #4 04-10-2019, 05:23 PM

I'd have thought it pretty obvious that you'd need to make some adjustments to the code for it to suit your particular needs - few of which you've specified. At the very least, you'd need to change the worksheet name in the code - and the accompanying discussion even draws attention to the kinds of changes you might need to make:

Quote:

The following macro populates a dropdown content control with whatever is in column A in "Sheet1" in the nominated workbook. You can change both the workbook and worksheet references via the StrWkBkNm and StrWkShtNm variables, respectively. The column and row references are managed in the 'For i = 1 To LRow ... Next' loop.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing Drop Down List to Combo Box	workingspade	Word	7	06-13-2024 01:17 AM
Letter Template /w combo box list	etruz	Word	4	10-31-2018 05:16 AM
Word 2010 Content Control help - Combo Boxes vs Drop Down List	proghy	Word	1	09-16-2014 02:01 PM
How can I add hyperlink to open a word file from an excel combo box selection?	mahmoudramadan	Excel	0	10-20-2012 10:41 AM
Bold list items in a combo box	DrewB	Word VBA	0	07-17-2009 11:32 AM