Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-03-2016, 02:53 AM
Doyougerrit Doyougerrit is offline How do I Get Link a result of a drop-down to an outcome? Windows 10 How do I Get Link a result of a drop-down to an outcome? Office 2016
Novice
How do I Get Link a result of a drop-down to an outcome?
 
Join Date: Aug 2016
Posts: 1
Doyougerrit is on a distinguished road
Unhappy How do I Get Link a result of a drop-down to an outcome?

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
Reply With Quote
  #2  
Old 08-03-2016, 05:05 PM
Guessed's Avatar
Guessed Guessed is offline How do I Get Link a result of a drop-down to an outcome? Windows 10 How do I Get Link a result of a drop-down to an outcome? Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,158
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
Reply

Tags
auto-populate, drop-down, macros



Similar Threads
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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft