Associating drop downs?

J

Jaye

Is it possible to create a drop down list in Column A and have it select a
Drop Down from a group of Drop Down lists and show up in Column B.
 
D

Dian D. Chapman, MVP

Yes, but you'd need to write VBA code to do it. Then you could code
automated macros that...when one item is selected, other form fields
are set to certain results.

You can check out my forms article at the link below for many ideas of
how to program forms for various situations. I don't particularly
cover this in my free articles (only in my VBA course), but many
similar issues are shown so you can get a bit of an idea of what you'd
need to do to get rolling.

Word AutoForms
http://www.mousetrax.com/techpage.html#autoforms

Dian D. Chapman, Technical Consultant
Microsoft MVP, MOS Certified
Editor/TechTrax Ezine

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
 
D

Doug Robbins

If you run a macro containing the following code on exit from the Dropdown
formfield ("ColA"), it will display the value that was chosen in a Text
formfield ("ColB")

ActiveDocument.FormFields("ColB").Result =
ActiveDocument.FormFields("ColA").DropDown.ListEntries
_(ActiveDocument.FormFields("ColA").DropDown.Value).Name

Having just put that together, it struck me that you can just use a cross
reference field in column B to the text of the bookmark assigned to the drop
down formfield and in the properties for that formfield, check the Calculate
on Exit box so that the cross reference field will be updated.
--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top