Radio button macro

C

ChrisK

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
 
C

ChrisK

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?
 
D

Doug Robbins - Word MVP

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


--
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
 
C

ChrisK

Thanks, thats what I thought

Doug Robbins - Word MVP said:
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


--
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
Click to expand...
 
L

Lori H.

Since macros are often disabled by company security settings, has Microsoft
made this any simpler yet (i.e., in Word 2007)?
Seems like an easy fix would be to add shape as a formatting option for
radio buttons (similar to other appearance choices like 3-D).
 
D

Doug Robbins - Word MVP

There are several levels of macro security and there there is no reason that
companies should prevent all macros from running. If they are going to do
that, they might as well go back to using typewriters.

--
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
 
Top