Excel Option buttons
 

How do I auto check an option button based on the state of another cell from
a different sheet? i.e. Cell = €œtrue€�, option button = €œtrue€�, cell = false,
option utton = false.

Excel Option buttons
 

Right-click on the option button, then select Properties. In the Properties
box, enter the desired sheet & cell next to 'Linked Cell'. For example,
Sheet2!B10. You must put an exclamation point (!) between the sheet name and
cell address. Also, if the sheet name contains a space, you must enclose it
in single quotes ('My Sheet'!B10).

When the linked cell has any value except zero or FALSE, the option button
will be TRUE. It the cell is zero or FALSE, the option button will be FALSE.
It the cell is empty, the option button will be grayed out.

Hope this helps,

Hutch

"AMS" wrote:

How do I auto check an option button based on the state of another cell from
a different sheet? i.e. Cell = €œtrue€�, option button = €œtrue€�, cell = false,
option utton = false.

Excel Option buttons
 

I apologize...the linked cell controling the option button is text (yes/no
selection). Can text activate/deactivate an option box?

"Tom Hutchins" wrote:

Right-click on the option button, then select Properties. In the Properties
box, enter the desired sheet & cell next to 'Linked Cell'. For example,
Sheet2!B10. You must put an exclamation point (!) between the sheet name and
cell address. Also, if the sheet name contains a space, you must enclose it
in single quotes ('My Sheet'!B10).

When the linked cell has any value except zero or FALSE, the option button
will be TRUE. It the cell is zero or FALSE, the option button will be FALSE.
It the cell is empty, the option button will be grayed out.

Hope this helps,

Hutch

"AMS" wrote:

How do I auto check an option button based on the state of another cell from
a different sheet? i.e. Cell = €œtrue€�, option button = €œtrue€�, cell = false,
option utton = false.

Excel Option buttons
 

I think the easiest way is to pick a cell that's out of the way (maybe in a
hidden column or row). Put an IF formula in that cell which returns 1 or 0
based on the yes/no text in the other cell. For example:

=IF(B7="yes",1,0)

Make the cell with the IF function the linked cell for the option button,
instead of the yes/no cell.

Hope this helps,

Hutch

"AMS" wrote:

I apologize...the linked cell controling the option button is text (yes/no
selection). Can text activate/deactivate an option box?

"Tom Hutchins" wrote:

Right-click on the option button, then select Properties. In the Properties
box, enter the desired sheet & cell next to 'Linked Cell'. For example,
Sheet2!B10. You must put an exclamation point (!) between the sheet name and
cell address. Also, if the sheet name contains a space, you must enclose it
in single quotes ('My Sheet'!B10).

When the linked cell has any value except zero or FALSE, the option button
will be TRUE. It the cell is zero or FALSE, the option button will be FALSE.
It the cell is empty, the option button will be grayed out.

Hope this helps,

Hutch

"AMS" wrote:

How do I auto check an option button based on the state of another cell from
a different sheet? i.e. Cell = €œtrue€�, option button = €œtrue€�, cell = false,
option utton = false.