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-09-2022, 11:25 PM

Guessed

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

Office 2016

Expert

Join Date: Mar 2010

Location: Canberra/Melbourne Australia

Posts: 4,176

Since you are adding the value
arrData1(0, lngIndex)

wouldn't it make sense to test if that is null rather than the value of
UBound(arrData1, 2)
which won't change during each step of the For/Next loop

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

« 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 03:54 AM.