Option buttons are kicking my tail....

[DThib]

I have a series of 8 option buttons and 1 text box in a frame. Whichever button or text box is selected. Enter yes or result (text box) and the remaining will show N/A (They all have their own cell in a row on the worksheet. When I run the code now. I get True or False for the option buttons results. Any idea how I can change these results to "Yes" or "N/A"?

Help!!!!

 

[Yongle]

easiest way is to use another range of cells with this formula to convert TRUE to Yes, and FALSE to N/A

=IF(G2=TRUE,"Yes","N/A")

 

[DThib]

easiest way is to use another range of cells with this formula to convert TRUE to Yes, and FALSE to N/A

=IF(G2=TRUE,"Yes","N/A")

Thanks, It worked!

DThib