Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-06-2018, 10:04 AM
VGW VGW is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2016
Novice
 
Join Date: Jul 2018
Posts: 7
VGW is on a distinguished road
Default

Where would I find the number of my content control? I applied the code however the other box is not populating.



I suspect that the reference is incorrect I am getting no errors.

That leads to a question on how the connect controls behave when inserted. Does the new one no matter where inserted on document become the highest number or are they numbered from beginning to the end?


Thank you for your input, I would give my age if I provided version and program that I used the last time I attempted VB. I found the content controls a welcome addition to word, (even more welcome when I figure out how to make them behave).
Reply With Quote
  #2  
Old 07-06-2018, 03:51 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: 22,467
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 # is the relative position in the document. An alternative is to give the output control a tag or title and reference it via that. See, for example, post #71 in this thread: https://www.msofficeforums.com/word-...tml#post120392
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-10-2018, 08:03 AM
VGW VGW is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2016
Novice
 
Join Date: Jul 2018
Posts: 7
VGW is on a distinguished road
Default Thank you

I found my error, before I can delete the multiple outputs. I needed to modify the selection values and pipes.

I had named my boxes, for ease of use however, I am now updating to remove spaces (again for ease of use).

May I ask a follow-up question?

What is the best method to apply the same functionality to multiple sets of controls within the same document?

Last edited by VGW; 07-10-2018 at 10:48 AM.
Reply With Quote
  #4  
Old 07-10-2018, 04:32 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: 22,467
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

Quote:
Originally Posted by VGW View Post
IMay I ask a follow-up question?

What is the best method to apply the same functionality to multiple sets of controls within the same document?
That depends. I suggest you start a new thread for that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 07-12-2018, 04:14 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: 22,467
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

It works exactly the same with Word 2016. Without actually seeing your document, it can be difficult for anyone to diagnose the issue. Can you attach the document to a post (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 07-12-2018, 11:47 PM
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 Paul

Thank you for your quick reply.

Attached is the document and it is all in swedish so let me know if that is an issue and I will translate it.

When you open the document you will have a bold line saying "Vi bifogar samtliga handlingar – antal sidor sidor."
This is the information I want to see more or less when selecting "för handläggning" in the dropdown menu.
Attached Files
File Type: docm LO-Rättsskydd.docm (61.3 KB, 28 views)
Reply With Quote
  #7  
Old 07-13-2018, 05:30 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: 22,467
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 document uses formfields, not content controls. The two are entirely different, so it's not surprising your not getting the desired results. For formfields, see: https://www.msofficeforums.com/word/...html#post46429
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
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
  #9  
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: 22,467
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
  #10  
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
  #11  
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
  #12  
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: 22,467
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
  #13  
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
  #14  
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: 22,467
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
  #15  
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, 25 views)
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 02:34 PM.


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