Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jaye
 
Posts: n/a
Default Associating drop downs?

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.
  #2   Report Post  
Dian D. Chapman, MVP
 
Posts: n/a
Default

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




On Sat, 12 Feb 2005 09:21:02 -0800, "Jaye"
wrote:

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.


  #3   Report Post  
Doug Robbins
 
Posts: n/a
Default

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.ListEnt ries
_(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
"Jaye" wrote in message
...
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.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
forms help - drop down boxes kimee11972 New Users 1 February 6th 05 01:36 PM
Word & Drop Down Menu's starkman Microsoft Word Help 1 January 2nd 05 10:39 PM
Drop downs Kerry Microsoft Word Help 1 December 22nd 04 03:53 AM
How does one get a drop down menu to drop down? TTMcG Microsoft Word Help 1 December 17th 04 04:59 AM
Drop down box MaBell Microsoft Word Help 1 December 11th 04 11:16 PM


All times are GMT +1. The time now is 12:48 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"