Radio button macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChrisK - 23 Mar 2008 20:39 GMT

I have three check boxes on a form. I there a macro I can use to limit a
check to only one of the three boxes?

Thanks

Reply to this Message

Jay Freedman - 23 Mar 2008 21:01 GMT

>I have three check boxes on a form. I there a macro I can use to limit a
>check to only one of the three boxes?
>
>Thanks

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

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

Reply to this Message

ChrisK - 23 Mar 2008 21:24 GMT

The article refers to check boxes in frames, is there anyway to do it without
framing the checkboxes? Would sections work if I added the appropriate breaks?

> >I have three check boxes on a form. I there a macro I can use to limit a
> >check to only one of the three boxes?
[quoted text clipped - 9 lines]
> Microsoft Word MVP FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

Reply to this Message

Doug Robbins - Word MVP - 23 Mar 2008 22:27 GMT

The checkboxes can be in any object that has a .Range

Paragraph
Table
Cell of a table
Section

Just replace the word Frames in the code with the object that you wish to
use. For example to make checkboxes in a Section of the document exclusive,
use:
Sub MakeCheckBoxesExclusive()

Dim oField As FormField

For Each oField In Selection.Sections(1).Range.FormFields
oField.CheckBox.Value = False
Next oField

Selection.FormFields(1).CheckBox.Value = True

End Sub

Signature

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

> The article refers to check boxes in frames, is there anyway to do it
> without
[quoted text clipped - 15 lines]
>> Email cannot be acknowledged; please post all follow-ups to the newsgroup
>> so all may benefit.

Reply to this Message

ChrisK - 23 Mar 2008 23:00 GMT

Thanks, thats what I thought

> The checkboxes can be in any object that has a .Range
>
[quoted text clipped - 37 lines]
> >> Email cannot be acknowledged; please post all follow-ups to the newsgroup
> >> so all may benefit.

Reply to this Message

Rate this thread: