microsoft.public.word.vba.general

Hi jlo,

If the user wants only Yes or No to be possible, why not use a dropdown in which 'Yes' and 'No' are the only options? Seems like a
lot less bother to me.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"jlo" wrote in message news:3BF20C13-F34B-4214-9064-5ED2E66582A1@microsoft.com...
>I inherited a Word fill-in form. I was told the yes and no check boxes were
> not working correctly. Instead of just using the yes, no check boxes, the
> user wanted the person who fills out the form to only select yes or no. If
> you select no, yes would be unchecked. I found a macro in the Macros dialog
> box.
>
> Sub MakeCheckBoxesExclusive()
> '
> ' MakeCheckBoxesExclusive Macro
> '
> Dim oField As FormField
>
> For Each oField In Selection.Frames(1).Range.FormFields
> oField.CheckBox.Value = False
> Next oField
>
> Selection.FormFields(1).CheckBox.Value = True
>
> End Sub
> --------------
> The problem is there are two fields prior to the yes, no check boxes and
> when you select yes or no the prior two fields information is removed. The
> form is setup in a table format. I'm not sure how to fix the VB code. I'm
> assuming it's the macro causing the problem.