radio buttons in XL2003

[Tonso]

I need to have 2 columns of radio buttons on a worksheet. If the left
button on row 10 is selected, then the value in cell F10 should be 5,
if the right button at row 10 is selected, the value in F10 should be
zero. If the left button at row 11 is selected, the value in F11 will
be 5. If the right button in row 11 is selected, the value in F11
should be zero. On each row from 10 - 21 [12 rows] one button will be
selected and the appropriate value [0 or 5] should appear in cells
F10:F21. My problem is, when i create multiple button, they all
reference the same one cell. How can i create multple button, and have
each button reference a difference cell?




Thanks,


Tonso

 

[Dave Peterson]

Saved from a previous post:

If your optionbuttons are from the Forms toolbar, the put all your optionbuttons
in each group in a groupbox (also on that Forms toolbar).

If your optionbuttons are from the Control Toolbox toolbar, then rightclick on
each optionbutton show the properties (you'll have to be in design mode for
this). Each group should have its own unique groupname.

If you're creating a survey form, you may want to look at Debra Dalgleish's
site:
http://contextures.com/xlForm01.html

============
You should be able to use a linked cell to return the user's choice. Then use
another cell with a formula to return the 5 or 0. You can hide the intermediate
linked cell column to make it look pretty.

I need to have 2 columns of radio buttons on a worksheet. If the left
button on row 10 is selected, then the value in cell F10 should be 5,
if the right button at row 10 is selected, the value in F10 should be
zero. If the left button at row 11 is selected, the value in F11 will
be 5. If the right button in row 11 is selected, the value in F11
should be zero. On each row from 10 - 21 [12 rows] one button will be
selected and the appropriate value [0 or 5] should appear in cells
F10:F21. My problem is, when i create multiple button, they all
reference the same one cell. How can i create multple button, and have
each button reference a difference cell?




Thanks,


Tonso

 

[Tonso]

Saved from a previous post:

If your optionbuttons are from the Forms toolbar, the put all your optionbuttons
in each group in a groupbox (also on that Forms toolbar).

If your optionbuttons are from the Control Toolbox toolbar, then rightclick on
each optionbutton show the properties (you'll have to be in design mode for
this).  Each group should have its own unique groupname.

If you're creating a survey form, you may want to look at Debra Dalgleish's
site:http://contextures.com/xlForm01.html

============
You should be able to use a linked cell to return the user's choice.  Then use
another cell with a formula to return the 5 or 0.  You can hide the intermediate
linked cell column to make it look pretty.

I need to have 2 columns of radio buttons on a worksheet. If the left
button on row 10 is selected, then the value in cell F10 should be 5,
if the right button at row 10 is selected, the value in F10 should be
zero. If the left button at  row 11 is selected, the value in F11 will
be 5. If the right button in row 11 is selected, the value in F11
should be zero. On each row from 10 - 21 [12 rows] one button will be
selected and the appropriate value [0 or 5] should appear in cells
F10:F21. My problem is, when i create multiple button, they all
reference the same one cell. How can i create multple button, and have
each button reference a difference cell?

Thanks,

Tonso

Thanks Dave....that did the trick!!

Tonso