Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2018, 05:33 AM
ajb ajb is offline Preparing a drop down with options to complete multiple fields Windows 8 Preparing a drop down with options to complete multiple fields Office 2016
Novice
Preparing a drop down with options to complete multiple fields
 
Join Date: Mar 2018
Posts: 4
ajb is on a distinguished road
Question Preparing a drop down with options to complete multiple fields

Hi all,



I am looking for some help. I want to create a letter template that has a 'signature' sign off at the bottom. At our firm we have 10+ employees, each with different contact information.

Say we have Bob and Joe. Both Bob and Joe use the same letter template, but I want the signature section of the letter to have a dropdown two options for their names only. Then, based on the option the user picks, the signature section will fill with their respective information.

The format is as per this image



Is someone able to help me in this? I know the dropdown can be used for a sole text selection but what about running a Macro?

Would appreciate any help.
Attached Images
File Type: png Dropodown.png (29.8 KB, 17 views)
Reply With Quote
  #2  
Old 03-23-2018, 02:47 PM
macropod's Avatar
macropod macropod is offline Preparing a drop down with options to complete multiple fields Windows 7 64bit Preparing a drop down with options to complete multiple fields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,466
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

What kind of dropdown do you propose to use? With formfields, for example, the whole lot can be done without recourse to macros.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 03-23-2018, 04:50 PM
Charles Kenyon Charles Kenyon is offline Preparing a drop down with options to complete multiple fields Windows 10 Preparing a drop down with options to complete multiple fields Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,853
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

If each uses a different computer or computer user, you could also simply use AutoText and an AutoText field for this. Each would have their own global template to hold this information. No drop-down needed.
Reply With Quote
  #4  
Old 03-23-2018, 05:22 PM
ajb ajb is offline Preparing a drop down with options to complete multiple fields Windows 8 Preparing a drop down with options to complete multiple fields Office 2016
Novice
Preparing a drop down with options to complete multiple fields
 
Join Date: Mar 2018
Posts: 4
ajb is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
What kind of dropdown do you propose to use? With formfields, for example, the whole lot can be done without recourse to macros.
Ah, perhaps fields are best. Just a list of about 10 names that will fill out their contact information in the spots denoted in the screenshot based on user selection.

I found your post here but I cant seem to format the output of the data (i.e. I cant get it to appear in the spots located in the screenshots.

I have attached word doc.
Attached Files
File Type: docm Content Controls - Dropdown Dependent Text.docm (32.3 KB, 7 views)
Reply With Quote
  #5  
Old 03-23-2018, 05:25 PM
macropod's Avatar
macropod macropod is offline Preparing a drop down with options to complete multiple fields Windows 7 64bit Preparing a drop down with options to complete multiple fields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,466
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

The attachment to that link uses content controls - and a macro. You need something more like: https://www.msofficeforums.com/word/...html#post46429
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #6  
Old 03-23-2018, 06:06 PM
ajb ajb is offline Preparing a drop down with options to complete multiple fields Windows 8 Preparing a drop down with options to complete multiple fields Office 2016
Novice
Preparing a drop down with options to complete multiple fields
 
Join Date: Mar 2018
Posts: 4
ajb is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
The attachment to that link uses content controls - and a macro. You need something more like: https://www.msofficeforums.com/word/...html#post46429
Hi Paul, unfortunately even after I unprotect that document changing the option in the dropdown results in no changes throughout the document. Is this user error or perhaps the file is from an older version of word?
Reply With Quote
  #7  
Old 03-23-2018, 06:51 PM
macropod's Avatar
macropod macropod is offline Preparing a drop down with options to complete multiple fields Windows 7 64bit Preparing a drop down with options to complete multiple fields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,466
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

You also need to change the conditions in the IF fields adjacent to the 'Code =' and 'Location =' texts. Did you do that?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #8  
Old 03-24-2018, 12:46 AM
ajb ajb is offline Preparing a drop down with options to complete multiple fields Windows 8 Preparing a drop down with options to complete multiple fields Office 2016
Novice
Preparing a drop down with options to complete multiple fields
 
Join Date: Mar 2018
Posts: 4
ajb is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You also need to change the conditions in the IF fields adjacent to the 'Code =' and 'Location =' texts. Did you do that?
I can't see any IF fields adjacent to Code and Location? Just the dropdown.
Reply With Quote
  #9  
Old 03-24-2018, 12:56 AM
macropod's Avatar
macropod macropod is offline Preparing a drop down with options to complete multiple fields Windows 7 64bit Preparing a drop down with options to complete multiple fields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,466
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Did you press Alt-F9 - as instructed in the link?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
dropdown, macro, visual basic

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Preparing a drop down with options to complete multiple fields Drop down options and controls in a Word form Begadoc Word 3 06-06-2016 03:14 PM
Preparing a drop down with options to complete multiple fields Multiple Dependant Drop Down Fields jsperry Word VBA 4 04-03-2016 03:39 AM
Drop down options for powerpoint stickynote45 PowerPoint 0 07-17-2015 11:26 AM
Preparing a drop down with options to complete multiple fields Drop down lists options inq80 Excel 2 10-17-2014 08:05 AM
Preparing a drop down with options to complete multiple fields Auto-complete and typing in drop down lists bcemail Word 1 03-27-2014 05:45 PM

Other Forums: Access Forums - Senior Forums

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


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