#1
|
|||
|
|||
Auto Populate Text On Dependent Drop Down Exit
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 Thanks in advance. |
#2
|
||||
|
||||
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
auto fill, dependent text, vba in microsoft word |
|
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 |