Help with Fillin Field, Macro Transfer

[LizW]

Hi there,

I work at a law firm and I have created a contact sheet which is a 2-page,
2-column table with Defendant's Contacts as the heading on the left side and
Plaintiff's Contacts on the right side. I have automated a macro using the
fillin field so that I can be prompted to add names and addresses into the
Defendant side of the table.

The problem is, we never have the same amount of contacts per case. So if I
had only 4 Defendant's Contacts, the Fillin field I programmed keeps going on
through the second page. I have to turn off each individual one. So I have 2
questions:

1. Is there a way to have the "cancel" on the fillin prompt dialog box
completely stop anymore fillin prompts from that point when I have reached
the limit of defendant's contacts?

2. Is there a way to then trigger new fillin prompts that go to the top
right of the page to fill out the Plaintiff's contacts and of course, stop it
when it is finished?

I'm not a pro at VBA so perhaps there are things I haven't even thought of
to accomplish this.

 

[Jay Freedman]

Hi Liz,

I'm afraid fillin fields are the wrong tool for this job. They're dumb
as dirt, intended for use with mail merges and not for manual input
with decision-making ability.

Instead, set up a template with a userform. See
http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm for a
short tutorial. If you still have questions after reading it, c'mon
back.

 

[G.G.Yagoda]

When all is said and done, it might be easier to just do it by hand.
You don't really gain anything with a user form since it requires the
same number of keystrokes.

 

[LizW]

Hi there!

Yes the user form worked but the only problem I am having is setting up the
veritical scroll bar. I put in the value of the height of the page (it won't
take anything less) and I tried setting scroll top but it only allowed me a
very little room to scroll.

The MVPS site didn't seem to have anything about this issue.

Thanks so much for your suggestion. It's really what they are wanting.