Form and Macro Problem

[Lily64]

I currently have a problem that seems simple but is not in Word and don't
know if it can be done. I'd appreciate any feedback anyone here may have
that may clarify for me if this can even be done in Word and if not, I'm
pretty sure I can do it in Excel, but the person I'm working for wants it in
Word if possible.

What I have are 4 documents (forms). They are all similar in nature in that
they are all 2 column forms with the left column content always staying the
same except for the variable form fields that will change according to the
client selected, but the right column would be defined by a dropdown box in
the left column that when choosing one of the options from that box, the
right column would change content to the other form data.

In case I'm not stating this clearly, I have posted a jpg kind of laying out
what I need. If any more clarification needs to be made, just let me know.
This is a little out of my range, but was hoping that maybe using VB there
was a way to do this.

Here is the sample using 2 of the forms. The other two are similar in that
the left column stays the same so the information doesn't need to be
repeated from page to page. They do not want a 4 page document. I figured
out how to run a macro and import the information from another file into
that column, but once I assigned a macro to the drop down box selection, I
was no longer able to lock the form, which is crucial. I need the content
in the change order to change only in the right side of the page and was
hoping a macro or programming of some sort would allow me to do this in
Word. Now I do the macro assigned to a button and I get vb runtime errors.

http://www.eliteofficesupport.com/clients/sample/

Thanks for any direction or assistance,
Lily

 

[Jean-Guy Marcil]

Lily64 was telling us:
Lily64 nous racontait que :

I currently have a problem that seems simple but is not in Word and
don't know if it can be done. I'd appreciate any feedback anyone here
may have that may clarify for me if this can even be done in Word and
if not, I'm pretty sure I can do it in Excel, but the person I'm
working for wants it in Word if possible.

What I have are 4 documents (forms). They are all similar in nature
in that they are all 2 column forms with the left column content
always staying the same except for the variable form fields that will
change according to the client selected, but the right column would
be defined by a dropdown box in the left column that when choosing
one of the options from that box, the right column would change
content to the other form data.

In case I'm not stating this clearly, I have posted a jpg kind of
laying out what I need. If any more clarification needs to be made,
just let me know. This is a little out of my range, but was hoping
that maybe using VB there was a way to do this.

Here is the sample using 2 of the forms. The other two are similar in
that the left column stays the same so the information doesn't need
to be repeated from page to page. They do not want a 4 page document.
I figured out how to run a macro and import the information from
another file into that column, but once I assigned a macro to the
drop down box selection, I was no longer able to lock the form, which
is crucial. I need the content in the change order to change only in
the right side of the page and was hoping a macro or programming of
some sort would allow me to do this in Word. Now I do the macro
assigned to a button and I get vb runtime errors.

http://www.eliteofficesupport.com/clients/sample/

Thanks for any direction or assistance,
Lily

You could do all this with formfields.
You could have one AutoText entry per item in the dropdown. The macro
associated with the OnExit even of the dropdown would read the dropdown
content and insert the appropriate AutoText entry in the right column.

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Lily64]

Thanks very much Jean-Guy. This works except that the form now will not
lock. This has been a real issue with the drop-down box. Every time I assign
a macro then save the document, it grays out the lock, so the form is
essentially useless. Any ideas why it is doing that??

 

[Lily64]

Alternatively, if I were to create 4 buttons, one for each form, how would I
assign a macro to the button to insert the appropriate text?

Thanks again,
Lily

 

[Jean-Guy Marcil]

Lily64 was telling us:
Lily64 nous racontait que :

Thanks very much Jean-Guy. This works except that the form now will
not lock. This has been a real issue with the drop-down box. Every
time I assign a macro then save the document, it grays out the lock,
so the form is essentially useless. Any ideas why it is doing that??

Are you using an ActiveX dropdown (from the Controls Toolbar) or a formfield
dropdown?

If the latter, what code are you using in the OnExit event of the dropdown?

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org