![]() |
|
#1
|
|||
|
|||
![]()
Hi,
I'm looking at creating interactive forms where if an option is selected from a drop-down, it automatically produces the outcome. For example, my drop-down is: Bob Dave Alan The title of the Drop-down is - Auditor So if I select Bob, I want the phrase - Firm but fair - to auto-populate. Likewise if I select Dave, I want the phrase - Critical and harsh - and Alan - Get away with anything. I've read a number of guides on the internet about Macro's but none of them put into layman's terms how I can achieve the desired affect. I have tried recreating the scenario's but draw a blank as soon as Microsoft Visual Basic for Applications open. I have no clue what to put in where and how. Any help would be greatly appreciated. I'm really drawing a blank. ![]() Thanks |
#2
|
||||
|
||||
![]()
There are two distinct ways of doing this.
This current thread shows one way that it can be achieved https://www.msofficeforums.com/word-...tml#post103038 Another is to use the building block type content control as described here http://gregmaxey.com/word_tip_pages/..._autotext.html
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
![]() |
Tags |
auto-populate, drop-down, macros |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data gathering from varied sources for different outcome letters | cs225 | Word | 2 | 10-19-2014 06:23 AM |
Link multiple cells in drop-down lists | Trial4life | Excel | 0 | 09-08-2014 05:08 AM |
Trying to link page numbers in the footer, but refuses to link after new section | fl0shizzle | Word | 7 | 05-06-2014 12:15 PM |
Adding a cropped .pdf, weird outcome! | Majten | Word | 0 | 12-14-2012 06:07 AM |
How to "hard link" two adjacent cells to a data validation drop down list? | Geza59 | Excel | 10 | 10-19-2012 11:56 AM |