how do i create an option button in a spreadsheet?
 

I am attempting to create a form in excel and I need the option button's
toggle feature. The form is broken down into various sections and I am
wanting to select the answer and have it record as the answer for each
section. Currently, as I go from section to section answering questions, the
option button follows and does not record my answer from the previous
section. What am I doing wrong?

how do i create an option button in a spreadsheet?
 

You have to isolate the option buttons from one another. Use a Group box
from the Forms toolbar. Option buttons inside one group box are isolated
from option buttons inside another group box.

--
Biff
Microsoft Excel MVP


"danab" wrote in message
...
I am attempting to create a form in excel and I need the option button's
toggle feature. The form is broken down into various sections and I am
wanting to select the answer and have it record as the answer for each
section. Currently, as I go from section to section answering questions,
the
option button follows and does not record my answer from the previous
section. What am I doing wrong?