Word Form or UserForm?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dreadnought8@hotmail.com - 05 Aug 2005 07:40 GMT

I have fairly complex form to automate. It's a planning tool, and has 6
separate worksheets, comprising mostly fairly straight forward check
boxes and text boxes, which the normal Word Forms feature seems to be
able to handle.
There are two things appear not so easy:

1. A couple of the worksheets may have multiple instances. Eg a
"Stakeholder Profile" worksheet collects information about a variable
number of stakeholders. A "Risk Profile" worksheet collects
information about a variable number of risks.

2. One of the worksheets has a "matrix" in which I want controlled user
data entry, that is, I want to control which cells they have access to,
and what values they may enter. This looks like it should be a table,
but I don't appear to be achieve what I want with a Word Form.

I'm confused over the availability of tables in Word Forms and
UserForms, and whether or not I can get control at the cell level.

I'm expert (blush) in Access VBA and don't mind a complex coding
solution.

I'd probably do this in Access or some other language but it looks like
Word 97 might provide a cheap and lightweight solution. Can it be
done?

Alternatively can anyone point me to a good book or site that I could
use?

TIA
Terry Bell

Reply to this Message

Anne Troy - 09 Aug 2005 22:59 GMT

Did you ever get this resolved? You might try something like this:
http://www.officearticles.com/word/create_a_fill-in_form_in_microsoft_word.htm
Now, when you want an extra "set of fields", you just create an autotext
entry (read about them here:
http://www.officearticles.com/word/using_autotext_in_microsoft_word.htm),
then give them a button to click that runs a macro like this (newsld is the
name of the autotext entry in this case):

Sub AddFields()

If ActiveDocument.ProtectionType <> wdNoProtection Then
ActiveDocument.Unprotect Password:=""
End If
Selection.MoveDown Unit:=wdLine, Count:=1
Selection.TypeParagraph
ActiveDocument.AttachedTemplate.AutoTextEntries("newsld").Insert _
Where:=Selection.Range, RichText:=True
ActiveDocument.Protect Password:="", NoReset:=True,
Type:=wdAllowOnlyFormFields

End Sub

************
Anne Troy
www.OfficeArticles.com

>I have fairly complex form to automate. It's a planning tool, and has 6
> separate worksheets, comprising mostly fairly straight forward check
[quoted text clipped - 27 lines]
> TIA
> Terry Bell

Reply to this Message