#16
|
|||
|
|||
Thanks man, it works! Now one more question: is it possible to link another content control to the drop-down list? Thanks |
#17
|
||||
|
||||
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] |
#18
|
|||
|
|||
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? |
#19
|
||||
|
||||
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#20
|
|||
|
|||
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. |
#21
|
||||
|
||||
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] |
#22
|
|||
|
|||
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 |
#23
|
||||
|
||||
If there's something you need help with, post your queries here.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#24
|
|||
|
|||
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 |
#25
|
||||
|
||||
You can locate the output content control in whatever Section of the document you'd like.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#26
|
|||
|
|||
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?
|
#27
|
||||
|
||||
This has nothing to do with the code but with where you place the output content control.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#28
|
|||
|
|||
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.
|
#29
|
||||
|
||||
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] |
#30
|
|||
|
|||
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |