Forms and Automated Text

  • Thread starter Thread starter Swifty_OE
  • Start date Start date
S

Swifty_OE

I'm trying to create a form that will automatically add text to various
fields after a value is chosen from a pull down menu.

For example if value X1 is chosen from pull down menu then value Y1 and Z1
will show up later in the form. If X1 is chosen from pull down menu then
value Y1 and Z1 will show ad ect.

Also is it possible to have the valued of one pull down menu based on the
selection of another?

Thanks-
 
Swifty_OE said:
I'm trying to create a form that will automatically add text to
various fields after a value is chosen from a pull down menu.

For example if value X1 is chosen from pull down menu then value Y1
and Z1 will show up later in the form. If X1 is chosen from pull down
menu then value Y1 and Z1 will show ad ect.

Also is it possible to have the valued of one pull down menu based on
the selection of another?

Thanks-

See http://gregmaxey.mvps.org/Linked_DropDown_Fields.htm.

While that page specifically answers your second question, the answer to the
first question is a similar technique. Just remove the code that loads items
into the second dropdown list, and replace that with code that puts the
desired values into text form fields.

If you have questions about writing the macros involved here, they would be
more likely to get answers in the newsgroup
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.word.vba.beginners.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 

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

Back
Top