Creating Case selection in Word 2003

[m2work]

Hello,

I am doing a qutotation template for my company which has 15 branch
locations. Instead of creating 15 different forms with different branch
information, I would like to use 1 form for all companies - if I select the
branch number, the branch info (address, phone/ fax #) will appear for the
branch. I tired using drop down list, but since it has to protect the form
and does not allow me to enter all the info, that does not work. Someone has
suggested to do a Case Selection in a macro, but unfortunately, I do not know
how.

Can someone shed some light on how this can be done?

Many thanks,
m2

 

[Cindy M.]

Hi =?Utf-8?B?bTJ3b3Jr?=,

I am doing a qutotation template for my company which has 15 branch
locations. Instead of creating 15 different forms with different branch
information, I would like to use 1 form for all companies - if I select the
branch number, the branch info (address, phone/ fax #) will appear for the
branch. I tired using drop down list, but since it has to protect the form
and does not allow me to enter all the info, that does not work. Someone has
suggested to do a Case Selection in a macro, but unfortunately, I do not know
how.

The better place to get help with macros is the word.vba.general ("Word
Programming") newsgroup. When you post, give a more complete explanation of what
you need. List a couple of branch numbers that you'd list in a form dropdown.
Also give names for the form dropdown as well as the form fields where you'd
like some of the branch information to appear. This way, people can set up a
meaningful code example for you.

You also need to think about where you want to manage this branch information.
You could hard-code it in your macro, but that makes it more difficult to
maintain down the road. What happens, for example, if the branch moves to a
different address? Or a new branch is added? Will someone have to edit the
macro? Or should the information be maintained in a separate file (could be
Excel, Word, plain text or XML, for example)?

If you decide to use a seperate file, you'll also need help on how to go about
setting this up.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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

 

[Graham Mayor]

Cindy - this has been the subject of a later separate thread. I think the OP
now has it sorted.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>