Not really sure if the Subject line will match my question.
I have a bunch of options buttons in an excel worksheet. I used the control
toolbox option buttons and in in caption i entered YES and NO according to
the option buttons. I linked the value to a cell in another worksheet that
will capture the value of the option button when checked. I grouped the
YES/NO buttons and when I click one button the other one looses its black
dot, and so on.
Basically I need to know how I can capture the value of the answer in a cell.
I tried this formula on a cell in the capture sheet
"=IF(C2="TRUE","YES","NO")"
But when the value of C2=TRUE the answer is NO, and if it is FALSE, the
answer is still NO. HElp. I am going in circles.. Thankyou.