Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-25-2017, 09:57 PM
emckillen emckillen is offline Creating text based on drop-down menu selection Mac OS X Creating text based on drop-down menu selection Office 2011 for Mac
Novice
Creating text based on drop-down menu selection
 
Join Date: Sep 2017
Posts: 5
emckillen is on a distinguished road
Red face Creating text based on drop-down menu selection

Using MS Word for Mac 2016 (version 15.32) but I'll take answers based on other iterations and on PC too.

I'm creating a template for legal proceedings.

I want the selection of an item in a drop-down menu to automatically generate a line of text elsewhere in the document. More specifically, I want the selection of the judicial district (on the top-left drop-down menu on the first page) to automatically generate the address of that district's courthouse (on the third page).

I also want the whole document to remain unlocked (I noticed when I add combo boxes or drop-down menus I seem to have to "protect form" to get them to function, locking down the ability to edit text anywhere besides the boxes/menus).

Not sure if a macro is necessary, but I'm a total newbie to macros.



I've attached the document and highlighted the relevant sections.

I would be deeply grateful to anyone who could give me a hand here. I've spent nearly a week trying to figure this out.
Attached Files
File Type: docx MBlank.docx (75.8 KB, 41 views)
Reply With Quote
  #2  
Old 09-26-2017, 09:21 PM
macropod's Avatar
macropod macropod is offline Creating text based on drop-down menu selection Windows 7 64bit Creating text based on drop-down menu selection Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See: https://www.msofficeforums.com/word-...html#post46903
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-27-2017, 03:44 PM
emckillen emckillen is offline Creating text based on drop-down menu selection Mac OS X Creating text based on drop-down menu selection Office 2011 for Mac
Novice
Creating text based on drop-down menu selection
 
Join Date: Sep 2017
Posts: 5
emckillen is on a distinguished road
Default

Thanks, but I downloaded the file, opened it and I see the dropdown menu (i.e. Roundhouse Nurseries and Smiths Wholesale) but when I select something, nothing happens.

Am I supposed to create a Macro to run on exit?
Reply With Quote
  #4  
Old 09-27-2017, 03:51 PM
macropod's Avatar
macropod macropod is offline Creating text based on drop-down menu selection Windows 7 64bit Creating text based on drop-down menu selection Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The required macro is already in the document. All you need do is make a selection then exit the dropdown.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 09-27-2017, 03:59 PM
emckillen emckillen is offline Creating text based on drop-down menu selection Mac OS X Creating text based on drop-down menu selection Office 2011 for Mac
Novice
Creating text based on drop-down menu selection
 
Join Date: Sep 2017
Posts: 5
emckillen is on a distinguished road
Default

Still not working. I make a selection, then click elsewhere in the document and nothing happens. I also tried pressing "tab" and nothing happens.

I see the empty "client details" field underneath but it never changes.

Keep in mind I'm opening it in MS Word for Mac 2016. I enabled marcos when opening it.

When I open it in the MS Word for PC, I get a read-only doc. See screen caps.
Attached Images
File Type: png Screen Shot 2017-09-27 at 6.55.59 PM.png (141.2 KB, 104 views)
File Type: png Screen Shot 2017-09-27 at 6.57.07 PM.png (71.4 KB, 98 views)
Reply With Quote
  #6  
Old 09-27-2017, 04:04 PM
macropod's Avatar
macropod macropod is offline Creating text based on drop-down menu selection Windows 7 64bit Creating text based on drop-down menu selection Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your PC version opens as read-only because the product has not been registered; I don't know why it's not working on the Mac, because MS is supposed to have added content control support to Word 2016 for the Mac. The alternative would be to use formfields and formula fields, as in: https://www.msofficeforums.com/word/...html#post46429
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 09-27-2017, 04:10 PM
emckillen emckillen is offline Creating text based on drop-down menu selection Mac OS X Creating text based on drop-down menu selection Office 2011 for Mac
Novice
Creating text based on drop-down menu selection
 
Join Date: Sep 2017
Posts: 5
emckillen is on a distinguished road
Default

I've tried going with the alternative (ie. using formfields and formula fields) but it seems I need to "protect form" for them to work, which treats my doc like a locked form. I want all text to remain editable.

Is there a way to do this? That is to say, have drop-down fields that trigger the creation of text in IF formula fields while keeping the whole document editable?
Reply With Quote
  #8  
Old 09-27-2017, 04:15 PM
macropod's Avatar
macropod macropod is offline Creating text based on drop-down menu selection Windows 7 64bit Creating text based on drop-down menu selection Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

With formfield protection, you can use Section breaks to delineate which parts of the document will be protected (i.e. those containing formfields) and which parts will be editable. You can achieve a reasonable level of granularity with multiple Section breaks.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 09-27-2017, 04:28 PM
emckillen emckillen is offline Creating text based on drop-down menu selection Mac OS X Creating text based on drop-down menu selection Office 2011 for Mac
Novice
Creating text based on drop-down menu selection
 
Join Date: Sep 2017
Posts: 5
emckillen is on a distinguished road
Default

Brilliant, thanks!

Last question:

How to I create multiple IF statements in one field?

I want a field to display different text depending on the selection of a drop down menu, so I that means I need something like:

{{IF "Dropdown1" = "Montreal", "Montreal Address"}{IF "Dropdown1" = "Laval", "Laval Address"}}

But that doesn't seem to work. It doesn't update when I go "update field".
Reply With Quote
  #10  
Old 09-27-2017, 04:52 PM
macropod's Avatar
macropod macropod is offline Creating text based on drop-down menu selection Windows 7 64bit Creating text based on drop-down menu selection Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Unless there is a particular reason for nesting the fields, e.g.:
{IF "Dropdown1" = "Montreal", "Montreal Address" {IF "Dropdown1" = "Laval", "Laval Address" "Neither Montreal nor Laval"}}
they can be independent:
{IF "Dropdown1" = "Montreal", "Montreal Address"}{IF "Dropdown1" = "Laval", "Laval Address"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
drop down menu, form fields, macro in word

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating text based on drop-down menu selection Drop down lists and pulling data from worksheet based on drop down selection cjoyce73 Excel 5 07-17-2017 07:40 AM
Creating text based on drop-down menu selection Drop-down menu in Excel, filling up the lists according to selection blackarrow Excel 18 01-18-2017 08:04 AM
Hide/Unhide Text Based on Drop Down Selection gw1500se Word 3 02-19-2015 12:17 PM
Creating text based on drop-down menu selection Adding text to after a bookmark based on drop down menu choice ksigcajun Word VBA 6 06-10-2014 09:39 AM
Populate a table based on choices from drop down menu Xaand Word VBA 0 02-25-2014 11:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:04 AM.


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