radio buttons independent for each row

[geebee]

i have like 40 radio button in my worksheet. there are 2 on each row. the
only problem is that all 40 seem to be related to each other. like when i
click yes in the first row, and no in the 10th row, the one for the first row
is cleared. how can i make it to where the "yes" and "no" in each row are
independent.

thanks in advance,
geebee

 

[Jim Thomlinson]

Depends where you got your radio buttons from as to how to make them
independant.

If they come from the forms toolbar (right clicking gives you the option to
assign a macro) then you just need to place a frme control around the buttons
you want linked. The frame control looks like a square with XYZ across the
top.

If your buttons come from the control toolbox then put your sheet into
design mode by clicking on the triangle and pencil icon. Now right click an
option button and select Properties. One of the properties is GroupName.
Change the group name for all of the buttons on a row to something like Row1.
That will link these buttons together...

 

[Dave Peterson]

And if you're only getting yes/no answers, maybe using a single checkbox per row
would make more sense.

Checked means yes, unchecked means no.

And you won't have to worry about grouping them, either.