Auto Populate Text On Dependent Drop Down Exit

GregStewartPTC · #1 02-24-2017, 06:56 AM

I have created a form built around dependent drop down lists. Drop down 1 feeds drop down 2 feeds drop down 3. I was not aware that text wrap does not work in drop down fields, so my 3rd drop down field isn't going to work as I had planned. What I would like to do instead is replace the 3rd drop down field with a text field that automatically populates with text based on the selection made in drop down 2. The end document will be used by multiple employee's, so I would like to code all of this through VBA into the document rather than using a select file method to reference documents on my personal computer. Just an example of the code I used for the first 2 drop downs for a point of reference:

Code:

Sub PopulateddPIP()

Select Case ActiveDocument.FormFields("ddKPI").Result

Case "ACW"

With ActiveDocument.FormFields("ddPIP").DropDown.ListEntries

.Clear

.Add "Not Multi Tasking"

.Add "Not Using Call Hx Templates"

.Add "Distracted by Personal Phone or Internet"

End With

Where drop down 1 is bookmarked as "ddKPI" and drop down 2 is bookmarked as "ddPIP". Any and all help is appreciated.

Thanks in advance.

macropod · #2 02-24-2017, 08:05 PM

For demonstrations of code to produce -

Dependent Dropdown Content Controls, see:
https://www.msofficeforums.com/word-...html#post77762

Hierarchical Dropdown Content Controls, see:
https://www.msofficeforums.com/word-...html#post94603

Dependent Text Content Controls, see:
https://www.msofficeforums.com/word-...html#post46903

macropod · #3 02-27-2017, 05:37 AM

Cross-posted at:
http://www.excelforum.com/word-forma...late-text.html
http://www.vbaexpress.com/forum/show...Drop-Down-Exit
https://www.office-forums.com/thread...-exit.2349864/
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to populate dependent dropdowns and auto-fill text fields simultaneously?	vera	Word VBA	1	10-07-2016 07:41 PM
VBA coding for multiple drop-down lists to populate a text box for each list	yeatropulo	Word VBA	14	11-11-2015 01:08 PM
cell text to auto populate if criteria matches	Jackie	Excel	2	02-06-2015 07:58 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
Auto populate text	help i'm stuck!	Word	1	08-13-2010 11:52 AM