Hi,
In my word document i have created two dropdown list. The first dropdown contains "names" and the second dropdown contains respective "phone numbers". Is it possible that selecting a name from the first dropdown will automatically change the second dropdown value based on the name selected in first dropdown? If yes, can you please tell how to do this. I am using word 2007.
Thank you.
You don't need two dropdowns for this unless your aim is to allow the user to select from either the list of names or the list of phone numbers. For an implementation of conditional output, see: http://www.msofficeforums.com/word/1...own-lists.html
Last edited by macropod; 05-06-2014 at 10:52 PM.
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Hi,
Thank you for replying.
The link which you have suggested helped me. In my document first line contains 'department code', second person 'name', and third 'Designation'. Based on the code from the above link, i was able to achieve this-selecting a value in first content control changes the second control accordingly. But how to also change the third content control value, i.e designation?. Can you please help further as i am new to vba. I have attached my document here. Thank you.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You could change your "" content control's values to, for example:
"Amar|Facilitator", for "Amar from H2"
and combine that with a macro coded like:
Alternatively, you could modify just the macro itself, so that nothing needs to be input as the "Details" content control values. For an example of that approach, see: http://www.excelforum.com/word-progr...into-word.html
Please Login or Register to view this content.
THANK YOU VERY MUCH!
one last question, what line of code should be used to perform action like-
If content control 1 value is "Fruit" then change content control 2 value to "Apple".
Have a nice day.
I'd have thought is perfectly obvious you'd use:
Fruit|Apple
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks