Need Another Option for Form

[Karen]

I have a form that I created in Word 2003 that is just a basic table. The
users will be filling this out electronically. There is a portion of the form
that the user has to make a choice from one out of two options, so I created
a radio button. Well, that doesn't work because of the security level here at
work is so high. Then I thought to create a macro and assign it to a command
button. When the user clicks either button, it places a checkmark in the
appropriate cell. Well, I guess the “assign macro†function is an Excel
feature. I don’t know how else to do this. Does anyone have any ideas?
Thanks, Karen

 

[Doug Robbins - Word MVP]

See the article "Making groups of Check Box Form Fields mutually exclusive
(so that they behave like radio buttons)†at:

http://www.word.mvps.org/FAQs/TblsFldsFms/ExclusiveFmFldChbxs.htm

The code can be modified so that it is not necessary to use a frame as long
as all of the check boxes that are to be mutually exclusive are in a
discrete range such as the range of a cell of a table or the range of a row
of a table, etc.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[Karen]

Thanks Doug! I'll check it out!
Karen

See the article "Making groups of Check Box Form Fields mutually exclusive
(so that they behave like radio buttons)†at:

http://www.word.mvps.org/FAQs/TblsFldsFms/ExclusiveFmFldChbxs.htm

The code can be modified so that it is not necessary to use a frame as long
as all of the check boxes that are to be mutually exclusive are in a
discrete range such as the range of a cell of a table or the range of a row
of a table, etc.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[Karen]

Doug,
I just read the instructions you referenced and I can't use because frames
cannot be in a table. I'm thinking of instructing the user to use ALT + 251
to enter the checkmark, but some users may be confused about that. I want to
make it as simple as possible. Any other suggestions?
Karen

 

[Doug Robbins - Word MVP]

As I said, you do not have to use frames.

If the checkboxes are in the the same row of a table, you can use:

Dim oField As FormField

For Each oField In Selection.Rows(1).Range.FormFields
If oField.Type = wdFieldFormCheckBox Then
oField.CheckBox.Value = False
End If
Next oField
Selection.FormFields(1).CheckBox.Value = True

If they are in the one cell, you can use:

Dim oField As FormField

For Each oField In Selection.Cells(1).Range.FormFields
If oField.Type = wdFieldFormCheckBox Then
oField.CheckBox.Value = False
End If
Next oField
Selection.FormFields(1).CheckBox.Value = True




--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com