Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
forms help - drop down boxes | New Users | |||
Word & Drop Down Menu's | Microsoft Word Help | |||
Drop downs | Microsoft Word Help | |||
How does one get a drop down menu to drop down? | Microsoft Word Help | |||
Drop down box | Microsoft Word Help |