Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office

Office / Word 2007 Is there a way to use a Drop Down List

Customer Question
Office / Word 2007 Is there...
Office / Word 2007
Is there a way to use a Drop Down List selection to populate text/fields in other areas of a document. I have a template that requires the user to select Company A or Company B, which then is referenced in a couple of locations in the document. I can't seem to get this to work and was hoping to avoid macros/code.
Any suggestions?
Submitted: 5 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 19 minutes by:
1/2/2013
Microsoft Office Technician: NewITZone, Computer Enthusiast replied 5 years ago
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience: I have been using Office Pro for 10 years and implemented applications for business use.
Verified
NewITZone :

Hi, Welcome to JustAnswer. This is Mahbub Shahin can assist you.
Please let me know when you will be ready?

JACUSTOMER-1a4udjwg- :

Ready

NewITZone :

Ok

NewITZone :

Please open the word file.

JACUSTOMER-1a4udjwg- :

I have a test document opened with a drop down list. List options are Company A and Company B. Ready!


NewITZone :

ok.

NewITZone :

Can you see the Developer menu

JACUSTOMER-1a4udjwg- :

Yes

NewITZone :

ok.

NewITZone :

Click on macro security

NewITZone :

Select all macro

JACUSTOMER-1a4udjwg- :

ok


NewITZone :

Also select trust access to the VBA...

NewITZone :

Then click on ok

JACUSTOMER-1a4udjwg- :

select enable all macros?

NewITZone :

Yes

JACUSTOMER-1a4udjwg- :

done...so this is going to require macro/vba. I was afraid that was going to be the case. Ok, next?

NewITZone :

Now let me know is it showing any error, if you select anything from the drop down list

JACUSTOMER-1a4udjwg- :

not seeing any error when I select from the DDL


NewITZone :

Now close the document and open it again to see is it working or not.

JACUSTOMER-1a4udjwg- :

stand by


NewITZone :

Ok. Please take your time.

JACUSTOMER-1a4udjwg- :

closed and open, DDL sections are working, no error

NewITZone :

Is it populate or not?

NewITZone :

I mean populate text in other areas of the document

JACUSTOMER-1a4udjwg- :

ok, I am confused. The DDL list is working, but we didnt set anything up to populate in other areas of the docuement

NewITZone :

Did you set any value?

JACUSTOMER-1a4udjwg- :

thats the question. How do I tie a field back to the DDL selection so that when a selection is made, it populates that field.


NewITZone :

ok.

NewITZone :

Could you please send me the file?

JACUSTOMER-1a4udjwg- :

I can send you the test file. Email?

NewITZone :

No, please attach it here

JACUSTOMER-1a4udjwg- :

oh....gotcha...one moment


NewITZone :

you will find a attachment icon click on it.

JACUSTOMER-1a4udjwg- :

got it


NewITZone :

ok.

NewITZone :

Hello.

JACUSTOMER-1a4udjwg- :

trying to get this doc attached. the attachment icon says insert/edit image

NewITZone :

Ok. Please click here www.wikisend.com

NewITZone :

after uploading the file please send me the link.

JACUSTOMER-1a4udjwg- :

DDL to Test list.docx

JACUSTOMER-1a4udjwg- :

Dont know if this is going to be any help though.


NewITZone :

Please send me the download link.

JACUSTOMER-1a4udjwg- :

ok...it wouldnt paste

NewITZone :

Did you copy the link?

JACUSTOMER-1a4udjwg- :

http://wikisend.com/download/529962/DDL to Test list.docx

NewITZone :

ok

NewITZone :

Is it your main document?

JACUSTOMER-1a4udjwg- :

this is not the document I am ultimately going to be working with. This is a test document I started just to figure out if this can be done and how to do it.

NewITZone :

Please hold on.

JACUSTOMER-1a4udjwg- :

take your time...I will be back in a moment

NewITZone :

ok.

JACUSTOMER-1a4udjwg- :

I am back

NewITZone :

Ok.

NewITZone :

Please hold on.

JACUSTOMER-1a4udjwg- :

ok...working on another document in the meantime, so take your time

NewITZone :

I am apologize.

NewITZone :

By using those commands one can create forms

JACUSTOMER-1a4udjwg- :

so to get this to work with those controls, it has to be a form (and thus, a protected document)?


NewITZone :

I do not find any way to make it work.

JACUSTOMER-1a4udjwg- :

ok...I guess I will have to go to microsoft support with this one. I appriciate your time working on this and although I didnt get a solution, I did at least get that I was not just missing something stupid and that it is not an easy solution.

NewITZone :

Please hold on.

JACUSTOMER-1a4udjwg- :

ok

NewITZone :

I opt out and leave this question for other experts if they have any idea.

NewITZone :

Please do not rate my service.

NewITZone :

Thank you for your continuous patience.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Richard, Software Specialist replied 5 years ago
Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 41,074
Experience: Over 15 year experience resolving Microsoft Office Issues
Verified
Hi there
I will look at this for you
But first are you still interested in continuing?
Let me know and I will look at document
Thank you
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago

yes...I was just in the process of reading about content controls using macro/vba. Apparently this is not something that can just be done with the integrated controls.

note, the "document" is just a test that pretty much does nothing

Microsoft Office Technician: Richard, Software Specialist replied 5 years ago
thanks
VBA is going to be needed.
But... can we do this in Excel? If we make it look like a document? as this will not require code than
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago

cannot be done in Excel. Ultimatly, this is going to be used in a template that is a Statement of Work docuement. The issue is our legal department, which has to approve the template I am creating, wants this SOW to be used intercompany as well as between our customers.

This means I needed to come up with a way to select which "company" was using the template and have that selection populate to make the template correct for that particular user. The hope was that I could take the value of the selected drop down list item to populate fields.

The issue is this: We (Company A) write a SOW between us and a customer. No problem. But, when we (Company A) are brough into a project by a sister group (Company B), the SOW has to be duplicated; one is between Company A and Company B and the other is between Company B and the customer. Company B becomes our customer in this case.

The SOWs are identical, so we only want to create the content once. Save 2 copies and basically select the "branding", if you will. A drop down with the inter-Company names for section solves the issue, as long as I can get that selection to populate in some key areas within the document. Otherwise, you would have to make multiple selections and that opens the door to user error. I am looking for a one and done solution.

Make sense?

Microsoft Office Technician: Richard, Software Specialist replied 5 years ago
ok, but without VBA correct?
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago

I was hoping to avoid VBA / Macros. These documents could get emailed around and filters these days at the servers have gotten so bad about stripping off attacments with macros and such.

I am willing to give it a shot if that is the solution. from what I am seeing on MS support forums, that is the way to go (and I think it should be rather simple code). I havent messed with VBA in years.

the setup is, I need one drop down list and there will be 3 or 4 areas in the template that need to reflect whatever is selected.

what do you think?

Microsoft Office Technician: Richard, Software Specialist replied 5 years ago
Email is going to stop the VBA from working, and you are going to get a lot of problems from people receiving it as an Email.
I will opt out though as another expert may know how to do this without VBA
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago

Ok....that's 2 that have opt'd out. I think at this point I am going to abandon the drop down list option and use text controls, which I know I can make work without VBA/Macros. It opens the door for user errors (typos), but that is just the risk we will have to take in order to make this work.

Thank you

Microsoft Office Technician: Rachel-Mod, Moderator replied 5 years ago
Rachel-Mod
Rachel-Mod, Moderator
Category: Microsoft Office
Satisfied Customers: 5
Experience: Moderator
Verified

Hello,

I’m a moderator for this topic. It seems the Professional has left this conversation. This happens occasionally, and it's usually because the Professional thinks that someone else might be a better match for your question. I've been working hard to find a new Professional to assist you with your question, but sometimes finding the right Professional can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!

Rachel

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago

I would cancel. I have decided to use another method. I know there is an answer but at this point I think it is going to be more in depth than needed right now.

Thank you!

Ask NewITZone Your Own Question
NewITZone
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
90 Satisfied Customers
Experience: I have been using Office Pro for 10 years and implemented applications for business use.

NewITZone is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

701 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

588 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
I have just had to reload /restore my Windows software as my
Hi, I have just had to reload /restore my Windows software as my system no longer logged onto the internet. One day to the next, it just would not show me Wifi connection details. I fixed that with th… read more
technicalcat
technicalcat
Computer Science
838 satisfied customers
It seems that a worksheet I was working on is no longer
It seems that a worksheet I was working on is no longer there. The workbook went white with small blocks at random places on the screen. I know I did not delete it. How can I recover it? It shows in t… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I have lost all my sheets below, on my Excel file - why? I
I have lost all my sheets below, on my Excel file - why? I have Excel 2007 … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I just recently I cannot send and receive the emails. When I
Hi I just recently I cannot send and receive the emails. When I click the button(send and receive)of tool bar, The message of "operation failure" comes up. Also, most buttons of tool bar doesn't work.… read more
Cody
Cody
Computer Science
1,716 satisfied customers
Running Outlook 2016 on Windows 7 machine. I disabled junk
Running Outlook 2016 on Windows 7 machine. I disabled junk in the program and the registry and it is still placing critical emails in the junk folder. How do I disable?… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
My MS 2016 stopped working. Win 10. No I haven't used it in
My MS 2016 stopped working JA: What application are you using? Customer: win 10 JA: Have you installed any updates recently? Customer: no I haven't used it in a while JA: Anything else you want the Mi… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Cannot get the security updates to go on Windows 10. No. is
Cannot get the security updates to go on Windows 10. No. is Oxc1900208 … read more
Cody
Cody
Computer Science
1,716 satisfied customers
If I want Office 365, can I buy it or do I have to Lease it?
If I want Office 365, can I buy it or do I have to Lease it ? … read more
RussellA
RussellA
Solutions Architect
Bachelor\u0027s Degree
123 satisfied customers
I bought it, but did not install. It would not install 365.
I bought it, but did not install JA: What application are you using? Customer: it would not install 365 JA: Have you installed any updates recently? Customer: no JA: Anything else you want the Microso… read more
Jason Jones
Jason Jones
AAS Information Technology
6,320 satisfied customers
Just updated the Office 16 automatically and neither of my
Just updated the Office 16 automatically and neither of my printers will print Word files. Will print when using old Office 11 program. What can I do? … read more
RussellA
RussellA
Solutions Architect
Bachelor\u0027s Degree
123 satisfied customers
Microsoft Outlook error messages: 0x8004210A. & 0x800Ccc92 I
Microsoft Outlook error messages: 0x8004210A. & 0x800Ccc92 I changed my Gmail password, causing these errors apparently. Today is my last day of membership.… read more
Kris R
Kris R
IT Manager
Computing
2,654 satisfied customers
Windows 10 is trying to update but stalls first at 75% and
windows 10 is trying to update but stalls first at 75% and then at 82%. It completely hangs up the system and we need to reboot three times to allow for a previous windows package to resume operation.… read more
D.Sandlin
D.Sandlin
Support Technician
6,708 satisfied customers
I've been working on a excel spreadsheet. I have 0ffice 365.
I've been working on a excel spreadsheet . I have 0ffice 365 . I've been working on the spread sheet for three days . I have this on a laptop . I was on my iPad deleting some excel spreadsheets . My c… read more
Kris R
Kris R
IT Manager
Computing
2,654 satisfied customers
I am on a computer away from my home computer in the desk of
Hi. I am on a computer away from my home computer in the desk of which is my microsoft license number. Can you help me? What information do you need? … read more
technicalcat
technicalcat
Computer Science
838 satisfied customers
M. -Burnett and I have had Microsoft as as I have had my
Hi, my name is***** and I have had Microsoft as long as I have had my computer. The problem is that my internet service, cell service, etc. was with Verizon and when they came in to set everything up,… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Something went wrong problem. Followed instructions to
Something went wrong problem. Followed instructions to uninstall Microsoft office. That was completed. Then lost contact at the point where instructions were given on how to reinstall office. Can you … read more
Jason Jones
Jason Jones
AAS Information Technology
6,320 satisfied customers
When I export an edited file from Word to gmail all of the
When I export an edited file from Word to gmail all of the text edits show up on the sent message. I have tired setting review and the trust center controls but can not get the default to be - do no d… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I keep getting a message that Word 10 is confederate. I have
I keep getting a message that Word 10 is confederate. I have the software and tried to enter the product key, but it says it is not right. We purchased this from cummunity college and We never had a p… read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
953 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x