Import list from Excel into drop-down content control in word

		Microsoft Office Forums > Microsoft Word > Word VBA
Import list from Excel into drop-down content control in word

FAQ

Thread Tools

Display Modes

08-08-2022, 01:44 PM

gmaxey

Windows 10 Import list from Excel into drop-down content control in word

Office 2019

Expert

Join Date: May 2010

Location: Brasstown, NC

Posts: 1,617

Perhaps:

For lngIndex = 0 To UBound(arrData, 2)
If Not IsNull(UBound(arrData, 2) then

oCC.DropdownListEntries.Add arrData(0, lngIndex), arrData(0, lngIndex)
End If

Next

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import list from Excel into drop-down list into word	ahw	Word VBA	43	02-28-2020 08:11 PM
Assigning Macro to Drop Down list Content Control	aussiew	Word VBA	5	03-10-2019 02:55 PM
Export Word Drop-Down Content Control to Excel Specific Sheet	nolanthomas32	Word VBA	4	09-19-2017 06:25 AM
How to get a Drop Down List Content Control box to fill in other areas	snips1982	Word	2	03-22-2017 03:37 AM
Word 2010 Content Control help - Combo Boxes vs Drop Down List	proghy	Word	1	09-16-2014 02:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:54 PM.