I am creating a survey question in excel with 7 radio/option buttons ranging
from "strongly agree" to "strongly disagree." Only one button can be selected
and I want each button to return return a unique numeric value (1 to 7) that
I will link to a cell in another worksheet.
I can do this easily using the option button in the "forms" toolbar but I
would like to use the options button located in the "control toolbox"
toolbar. However, when I try, the only output I get is true or false.
Please help.