Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 08-11-2014, 11:39 PM
vincente vincente is offline Multiple entries in dropdown lists Windows 7 32bit Multiple entries in dropdown lists Office 2010 32bit
Novice
 
Join Date: Aug 2014
Posts: 4
vincente is on a distinguished road
Thumbs down

Thanks man, it works!



Now one more question: is it possible to link another content control to the drop-down list?

Thanks
Reply With Quote
  #17  
Old 08-12-2014, 12:32 AM
macropod's Avatar
macropod macropod is offline Multiple entries in dropdown lists Windows 7 32bit Multiple entries in dropdown lists 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

That's quite easy, but I can't give specific advice without knowing how much of the data are to be replicated.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #18  
Old 08-14-2014, 02:35 AM
vincente vincente is offline Multiple entries in dropdown lists Windows 7 32bit Multiple entries in dropdown lists Office 2010 32bit
Novice
 
Join Date: Aug 2014
Posts: 4
vincente is on a distinguished road
Default

Ok, so forget about what I said about linking another content control to the drop down list.

What I need to do now is add another drop down list that updates another content control in the same document. They need to be completely seperate from the previous combo dropdown/content control.

The problem is that when I copy the drop down list and the content control from your example and paste it to the document where I already have pasted a dropdownlist/content control, and i try to test it, the screen switches to VBA and says 'compile error: can't find project or library'.

Can anybody please help me out?
Reply With Quote
  #19  
Old 08-14-2014, 02:55 AM
macropod's Avatar
macropod macropod is offline Multiple entries in dropdown lists Windows 7 32bit Multiple entries in dropdown lists 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

Post #9 in this thread already describes how you would go about adding more sets.

Although that post refers to identifying the target content controls by index number, a better way might be to reference them via their own titles, using code like:
Code:
ActiveDocument.SelectContentControlsByTitle("ClientDetails").Item(1).Range.Text = StrDetails
As for the error message, I don't know what that's about - the code works fine with multiple content controls in my testing.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #20  
Old 03-02-2015, 09:43 AM
Wordz Wordz is offline Multiple entries in dropdown lists Windows 7 32bit Multiple entries in dropdown lists Office 2007
Novice
 
Join Date: Mar 2015
Posts: 1
Wordz is on a distinguished road
Default

Hi Paul,

I'm new to the forum, but when copying across the macro and the content controls from your Word doc above, what elements of the Macro need to be amended so it works in my document? As I can only see a reference to "Client" but no reference to "Client Details" in the Macro. So unsure how to proceed. Many thanks.
Reply With Quote
  #21  
Old 06-05-2015, 03:51 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,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

Hi Wordz,

I've been away for 3 1/2 months, hence the delay in replying.

The reason the macro doesn't refer to "Client Details" is that the "Client Details" content control is referred to by its relative position in the document (content control # 2) rather than by name.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #22  
Old 08-24-2015, 01:10 PM
cole.snavely cole.snavely is offline Multiple entries in dropdown lists Windows 8 Multiple entries in dropdown lists Office 2010 64bit
Novice
 
Join Date: Aug 2015
Posts: 1
cole.snavely is on a distinguished road
Default

Would you be willing to discuss this in more detail with me? Your template is great, just not sure how to edit it to work with my stuff. Thanks so much!

Last edited by macropod; 08-24-2015 at 04:26 PM. Reason: Email address removed for privacy
Reply With Quote
  #23  
Old 08-24-2015, 04:26 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,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

If there's something you need help with, post your queries here.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #24  
Old 10-22-2015, 08:55 AM
maverick561145 maverick561145 is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 64bit
Novice
 
Join Date: Oct 2015
Posts: 8
maverick561145 is on a distinguished road
Default

I have been trying to find a way to duplicate the information in my content control box1 elsewhere in my document..

Last edited by maverick561145; 10-22-2015 at 02:28 PM. Reason: sounds better
Reply With Quote
  #25  
Old 10-22-2015, 12:37 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,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

You can locate the output content control in whatever Section of the document you'd like.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #26  
Old 10-22-2015, 03:06 PM
maverick561145 maverick561145 is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 64bit
Novice
 
Join Date: Oct 2015
Posts: 8
maverick561145 is on a distinguished road
Default

I have got the dropdown lists all filled in and my document pretty much filled out. so in my code how do I word that?
Reply With Quote
  #27  
Old 10-22-2015, 03:11 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,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

This has nothing to do with the code but with where you place the output content control.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #28  
Old 10-23-2015, 09:23 AM
maverick561145 maverick561145 is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 64bit
Novice
 
Join Date: Oct 2015
Posts: 8
maverick561145 is on a distinguished road
Default

I still can't figure out how to get the information that is in the content control dropdown to transfer into another location. I can get the address of the customer to but not the customer name. what am I doing wrong.
Reply With Quote
  #29  
Old 10-23-2015, 01:38 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,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

You hadn't previously said you wanted both the name and the address in another location. In that case, you will need to change the code. I see that you have now edited post #32 to say that, but that's not what you asked at the time...

Change:
StrDetails = Replace(.DropdownListEntries(i).Value, "|", Chr(11))
to:
StrDetails = .Range.Text & Chr(11) & Replace(.DropdownListEntries(i).Value, "|", Chr(11))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #30  
Old 10-26-2015, 07:59 AM
maverick561145 maverick561145 is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 64bit
Novice
 
Join Date: Oct 2015
Posts: 8
maverick561145 is on a distinguished road
Default

I appreciate your help. But I must still be doing something wrong. I have changed the code and now I am getting this.
Roundhouse Nurseries
Roundhouse Nurseries
Phone: 08 1111 1111
Fax: 08 2222 2222
Email: sales@roundhousenurseries.com.au


But it is still not going into the second location that I need it to go into. Maybe its not possible or I am missing the whole concept, and that's a for sure possibility. I would like to pick a customer from my dropdown list on page one and have it insert into a section on page 2 without having to go and choose the customer from the dropdown list on page 2. Like I said earlier I can get the address to insert just fine on page 2 just not the name. is this something that is possible?
Reply With Quote
Reply

Thread Tools
Display Modes


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:19 PM.


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