# Option buttons are kicking my tail....

#### DThib

##### Active Member
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!!!!

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

#### Yongle

##### Well-known Member
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")

Last edited:

#### DThib

##### Active Member
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

Last edited:

Replies
2
Views
79
Replies
3
Views
82
Replies
1
Views
85
Replies
2
Views
72
Replies
10
Views
139