Thanks Marcopod for your zip attachment. I've been following this thread and being new to VBA, I'm trying to figure out where in the macro I type in what text to display.

E.g., what i need is for someone to be abe to see full words in a dropdown list, but then display a Code corresponding to each word. I could have the code included in the dropdown with the word, then possibly only set it to show the first x characters (to only display the code). Any way to just display the code, and not the full words would be helpful. The macro looks like its what I need, but I cant figure out what text goes where.



I will have 4 separate dropdown lists with each list repeating down four to five lines.

Thanks,

The values to display have been input into the first content control. That content control has both a Display text and a Value. The conditional outputs are stored in the value field, with | delimiters for each output line.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

this is exactly what i'm looking for... But i know nothing about vba/macro's... can anybody quickly explain to me how to link the drop-down list to the text box?
I've tried copy-pasteing macropod's example, but that doesn't seem to work...

cheers

There is no textbox in the attachment demo, just two content controls and the macro that does the updating.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

ok, but the problem is that this is all new to me and i don't have a clue how to make it myself.

could you help me with this?

Open the document and click on the ¶ symbol on the Ribbon's Home tab to display the document's formatting. You should now be able to see that there are two content controls, separated by a manual line break, with a paragraph break following the second one. Click on the Ribbon's Developer tab, then on 'Design Mode'. This should make the content controls even more apparent and will reveal their titles - Client and ClientDetails, respectively.

To use these controls as-is in your own document, simply copy both of them, plus the macro code to your document. To change the Client dropdown's contents, click on it, then on 'Properties' on the Developer tab. There you can add/delete/modify the entries. Pay particular attention to how the DisplayName and Value are input, especially the latter.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks man, it works!

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

Thanks

Paul,

I do not see any macro code to copy. Is there someplace special I should be looking for the code?

Tim M

Hello,
I'm trying to create an invoice template. Is there a possibility to have 3 text fields filled out depending on whats chosen in a dropdown list? The problem is that the text for each field needs to be a different one. Everything is supposed to be in one line in a table that can be replicated using ContentControl.
E.g.:

Product Name (from dropdown list)
-> Product number
-> Additional info
-> Price

Thanks in advance

Enci

Hi Macropod

I am having difficulty to get your macro to work in my document. (I have never used macros before)

I have been creating a word template.
I copied across - Client and client details.
I dont know how to copy and paste the macro across so it will work in my template.

Also, does my template have to be saved as a word enabled template for it to work?

Thank you

I'm attaching the same document that I successfully got working earlier in this thread. When I recently added three names to my dropdown, the macro that updates names and phone numbers stopped working for my coworkers, but not for me! Not sure what's different on my machine vs. theirs. Thoughts?



Seth

Attached Files

Proposal Sheet Test.docm (105.5 KB, 137 views)

Ok I admit it, I am no Word Wizard.
I have a word document with a drop down of three selections (so far) I want to move the value of each or even multiple selections down to a control text area in the document template below.

I know nothing about Macros, it's my first try at them. Driving me crazy. Two days. Sugar and caffeine high come and gone multiple time. Now at the "pulling out hair stage", don't want to progress to the "banging head on desk" stage.

And any VB experience I have is over 25 years old, and haven't used VB in over 15 years.

Someone said record what you want it to do, it is as simple as start recording the macro, clicking on the drop down selection and then clicking on the text control area and then clicking stop on the macro recorder?

Or am I missing a large part of all of this?
HELP!

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,

Hello, I successful got this to work in my document. Thank you! However, I would like to have this work in the Header of Word. I keep getting an error message on this line of the VBA code. Is it possible?
ActiveDocument.ContentControls(2).Range.Text = StrDetails

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]