Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #106  
Old 07-15-2018, 03:20 AM
tostrand tostrand is offline Multiple entries in dropdown lists Windows 10 Multiple entries in dropdown lists Office 2016
Novice
 
Join Date: Jul 2018
Posts: 4
tostrand is on a distinguished road
Default


Hi
My document have both I admit the majority of fienlds are formfields but the one I am trying to get to work in a content control field. Can't they co exist?
Reply With Quote
  #107  
Old 07-15-2018, 03:25 AM
macropod's Avatar
macropod macropod is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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 attachment has no content controls that I can see; only 15 formfields. Furthermore, you should not use formfields and content controls in the same document; they weren't designed to work together and trying to use both in the same document is a known source of problems.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #108  
Old 07-15-2018, 03:57 AM
tostrand tostrand is offline Multiple entries in dropdown lists Windows 10 Multiple entries in dropdown lists Office 2016
Novice
 
Join Date: Jul 2018
Posts: 4
tostrand is on a distinguished road
Default

Hi again

I changed all formfields to content controls and got it working. Thank you so much for the help!
Reply With Quote
  #109  
Old 10-21-2018, 11:58 PM
darkfaith darkfaith is offline Multiple entries in dropdown lists Windows 8 Multiple entries in dropdown lists Office 2013
Novice
 
Join Date: Jul 2016
Posts: 4
darkfaith is on a distinguished road
Default

Hi there, I'm not sure if anybody still visit this thread but my problem comes from one of the 'solution' which i downloaded from here.
I have the dropdown list figured out, where value is different from display name (under the Content Control Properties).
My problem is, what if I want the value to be the same for some of the display names (about more than 5 of them, so inserting "space/blanks" isn't ideal)?

Example:
(Dropdown selection) Roundhouse Nurseries
(Value) Phone: 08 1111 1111 | Country: USA

(Dropdown selection) Smiths Wholesales
(Value) Phone: 08 3333 3333 | Country: USA

(Dropdown selection) Roundhouse&Smiths Wholesales
(Value) Phone: 08 3333 3333 | Country: USA

Thanks so much in advance!
Reply With Quote
  #110  
Old 10-22-2018, 04:08 AM
macropod's Avatar
macropod macropod is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

You cannot have duplicate dropdown entry display names; you can, however, have duplicate dropdown entry values. Personally, I'd rely on something other than spaces to differentiate display names that would otherwise be duplicates; doubtless, you can think of a characteristic that each entry has that differentiates it from the others (e.g. a State).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #111  
Old 01-28-2019, 02:33 PM
jsalas jsalas is offline Multiple entries in dropdown lists Windows 10 Multiple entries in dropdown lists Office 2013
Novice
 
Join Date: Jan 2019
Posts: 4
jsalas is on a distinguished road
Default How to implementing a macro

Hello, I am new to macros and was wondering if you could advise the best way to link two content controls. In the first I am displaying LocalPostOffice and in the second is LPOEmail. The intent is to select the local post office by name and have the field populated with the corresponding email. I'd greatly appreciate any advice you might have.
Reply With Quote
  #112  
Old 01-28-2019, 04:03 PM
macropod's Avatar
macropod macropod is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Did you try the example in post #2? Did you modify the dropdown's text & value parameters to suit your needs?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #113  
Old 02-01-2019, 02:29 PM
jsalas jsalas is offline Multiple entries in dropdown lists Windows 10 Multiple entries in dropdown lists Office 2013
Novice
 
Join Date: Jan 2019
Posts: 4
jsalas is on a distinguished road
Default

Macropod,

Yes, I followed your instructions and am to get it to work in the CC document you included, but am having issues when I copy it over to a new document. When I select from the drop down nothing is happening. Conversely, I have sent the document to two other users to test, it worked for one and not for the other. I am stumped.
Attached Files
File Type: zip VBA.zip (129.2 KB, 23 views)
Reply With Quote
  #114  
Old 02-01-2019, 03:29 PM
macropod's Avatar
macropod macropod is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

As post #2 says, the process is managed via an on_exit macro. Did you copy that from the demo file into your own document?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #115  
Old 02-04-2019, 06:00 AM
jsalas jsalas is offline Multiple entries in dropdown lists Windows 10 Multiple entries in dropdown lists Office 2013
Novice
 
Join Date: Jan 2019
Posts: 4
jsalas is on a distinguished road
Default

I believe I did, when I check it in VBA I am seeing "Document" and "ContentControlOnExit" in the drop down next to it.
Reply With Quote
  #116  
Old 02-04-2019, 01:00 PM
macropod's Avatar
macropod macropod is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

And is that macro in the 'ThisDocument' code module of you document or its template - as shown in the attachment to post #2?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #117  
Old 02-08-2019, 05:59 AM
jsalas jsalas is offline Multiple entries in dropdown lists Windows 10 Multiple entries in dropdown lists Office 2013
Novice
 
Join Date: Jan 2019
Posts: 4
jsalas is on a distinguished road
Default

Yes, I copied the macro over from the original document you uploaded after updating the content controls. I've attached my document, and would greatly appreciate any insight you might have.

Last edited by jsalas; 02-08-2019 at 02:20 PM.
Reply With Quote
  #118  
Old 02-08-2019, 01:07 PM
macropod's Avatar
macropod macropod is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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 code in your document works as is for me. All one need do is select an entry an exit the dropdown. If that's not working for you, check your macro security settings.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #119  
Old 05-19-2019, 06:47 AM
Jfisher88 Jfisher88 is offline Multiple entries in dropdown lists Mac OS X Multiple entries in dropdown lists Office 2019
Novice
 
Join Date: May 2019
Posts: 2
Jfisher88 is on a distinguished road
Default

Hi!

I downloaded your example and I have word opened. I can't modify or add different names the group though. I'm using version 15.4. If that helps. Also can you add this above a header? I've been trying to create a list of 5 different names and I can't seem to add a list above it.

Thanks,
Reply With Quote
  #120  
Old 05-19-2019, 03:31 PM
macropod's Avatar
macropod macropod is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Changing the dropdown entries and outputs is as simple as editing the content control properties, which you can access via the Developer tab. See: https://support.office.com/en-us/art...4-0685ae00e9b4

You can have the content controls wherever you want them. Do be aware, though, that when they're placed in a header or footer, exiting them in a way that closes the header or footer won't trigger the on-exit macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple entries in dropdown lists Delete Multiple Entries dudeabides Office 1 07-04-2011 02:49 AM
Multiple task lists and multiple calendars kballing Outlook 0 01-18-2011 10:23 AM
Creating Multiple Contact Lists meltee78 Outlook 1 01-03-2011 09:45 PM
multiple calendar entries across a group halfhearted Outlook 0 10-11-2009 12:13 PM
Word Forms : Dropdown lists wferaera45 Word 0 04-06-2006 03:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:46 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