Hi Beth,
I am working in office word 2003. I am creating a
selection sheet for our clients to choose their menu for a river trip. When
someone, for example, chooses a pasta from the drop down menu, they also need
to choose a sauce for it. I am trying to prompt them to make the choices
automatically.
I hope that explains it.
Yes, you definitely need to use a VBA (macro) solution. It would have to be
assigned to the "On exit" property in the form fields "Options" dialog box. The
macro would pick up the selection, unprotect the form, fill the other dropdown
box, then reprotect the document.
Alternately, you could use an "On Enter" macro with two TEXT boxes. This would
display a UserForm where the user could make both choices at the same time (the
advantage would be that the form wouldn't need to be unprotected/reprotected).
1. you have to determine whether your document is allowed to contain macros.
Macros will trigger Word's macro security, meaning your document probably wouldn't
be available to all users.
2. You have to decide how you want to manage the data. It can be hard-coded into
the macro, which means whenever anything would change you'd have to edit the macro
code. Or the data could be managed in an outside file. This would be more flexible
to maintain, but more difficult to code.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail
