Radio buttons do not work.

[sukumar.rajasekhar]

Hi!

I am trying to create a form in Excel using Radio Buttons and am having
trouble with them. For instance: When I choose a boolean selection
between two radio buttons Yes and No in line 1 and then go to line 2
and choose between Yes and No, my previous selection in line 1 gets
deselected and when I proceed further to line 3, the line 2 selection
gets deselected and vice versa.

I would like to know how I can retain a boolean selection in every
line.

Please let me know.

Thanks in advance

Sukumar

 

[Bob Phillips]

Use checkboxes, each signifies on/off or Yes/No.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Dave Peterson]

I'd use Bob's suggestion, too.

But if you used the optionbuttons from the Forms toolbar, then draw a GroupBox
around each pair of optionbuttons. (The groupbox is also on the Forms toolbar.)

If you used optionbuttons from the Control toolbox toolbar, then right click on
each and change the groupname. Use a unique groupname for each pair of
optionbuttons.

(The default groupname is the sheet name--that's why they're all grouped
together.)