Option buttons are kicking my tail....

DThib

Active Member
Joined
Mar 19, 2010
Messages
427
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!!!!
:confused::confused:
 

Some videos you may like

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
Joined
Mar 11, 2015
Messages
6,746
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Mar 19, 2010
Messages
427
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:

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,203
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top