Drop Down List to Automatically Populate Data in a Table

		Microsoft Office Forums > Microsoft Word > Word VBA
Drop Down List to Automatically Populate Data in a Table

FAQ

Thread Tools

Display Modes

12-03-2020, 04:15 PM

macropod

Windows 10 Drop Down List to Automatically Populate Data in a Table

Office 2010

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

Replace:

Code:

        For j = 2 To 7
          .Cell(i, j).Range.Text = Split(StrTmp, ",")(j - 2)
        Next

with

Code:

        For j = 2 To 7
          With .Cell(i, j).Range.ContentControls(1)
            .LockContents = False
            .Range.Text = Split(StrTmp, ",")(j - 2)
            .LockContents = True
          End With
        Next

See attached.

Attached Files

Pre-Populate Table Data.docm (42.0 KB, 10 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto populate form (data from excel) in Word based on drop down list selection (data from excel)	wvlls	Word VBA	1	03-22-2019 02:29 PM
Populate grocery list from drop down menu	jlshanke	Excel	3	08-21-2018 07:28 AM
How to add automatically another drop-down list after insertion of data	doomie83	Word VBA	1	04-19-2016 04:28 PM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data	Faldinio	Word VBA	7	10-19-2014 06:03 AM
Populate dropdown list with data from Access table	spw4000	Office	0	02-24-2012 05:22 AM