How do I change the value of a linked cell when using toggle button or check
box I am using Excel 2003

In Design Mode, right-click - Properties

--
Jim
"Randy" wrote in message
...
| How do I change the value of a linked cell when using toggle button or
check
| box I am using Excel 2003

I've gone through properties and can't seem to change it there either,
although it seems like that is where to make the changes. Am I doing
something wrong?

"Jim Rech" wrote:

In Design Mode, right-click - Properties

--
Jim
"Randy" wrote in message
...
| How do I change the value of a linked cell when using toggle button or
check
| box I am using Excel 2003

It's "Linked Cell" in the Properties.

--
Jim
"Randy" wrote in message
...
| I've gone through properties and can't seem to change it there either,
| although it seems like that is where to make the changes. Am I doing
| something wrong?
|
| "Jim Rech" wrote:
|
| In Design Mode, right-click - Properties
|
| --
| Jim
| "Randy" wrote in message
| ...
| | How do I change the value of a linked cell when using toggle button or
| check
| | box I am using Excel 2003
|
|
|

I've got the linked cell, but I can't seem to control the data in the linked
cell. All I can get is a TRUE or a FALSE. I want to be able to dictate what
the linked cell displays when the toggle button is used.

"Jim Rech" wrote:

It's "Linked Cell" in the Properties.

--
Jim
"Randy" wrote in message
...
| I've gone through properties and can't seem to change it there either,
| although it seems like that is where to make the changes. Am I doing
| something wrong?
|
| "Jim Rech" wrote:
|
| In Design Mode, right-click - Properties
|
| --
| Jim
| "Randy" wrote in message
| ...
| | How do I change the value of a linked cell when using toggle button or
| check
| | box I am using Excel 2003
|
|
|

What values do you want to see?

True, false, or null, are the only values that make sense to me.


On Oct 30, 12:32 pm, Randy wrote:
I've got the linked cell, but I can't seem to control the data in the linked
cell. All I can get is a TRUE or a FALSE. I want to be able to dictate what
the linked cell displays when the toggle button is used.

"Jim Rech" wrote:
It's "Linked Cell" in the Properties.

--
Jim
"Randy" wrote in message
...
| I've gone through properties and can't seem to change it there either,
| although it seems like that is where to make the changes. Am I doing
| something wrong?
|
| "Jim Rech" wrote:
|
| In Design Mode, right-click - Properties
|
| --
| Jim
| "Randy" wrote in message
| ...
| | How do I change the value of a linked cell when using toggle button or
| check
| | box I am using Excel 2003
|
|
|

Like Dan say, the value of the togglebutton is true or false for pressed or
not pressed. If you want a cell to say something based on this value you'd
have to put it in another cell, like =IF(A1=TRUE,"Toggle Down","Toggle Up")

--
Jim
"Randy" wrote in message
...
| I've got the linked cell, but I can't seem to control the data in the
linked
| cell. All I can get is a TRUE or a FALSE. I want to be able to dictate
what
| the linked cell displays when the toggle button is used.
|
| "Jim Rech" wrote:
|
| It's "Linked Cell" in the Properties.
|
| --
| Jim
| "Randy" wrote in message
| ...
| | I've gone through properties and can't seem to change it there either,
| | although it seems like that is where to make the changes. Am I doing
| | something wrong?
| |
| | "Jim Rech" wrote:
| |
| | In Design Mode, right-click - Properties
| |
| | --
| | Jim
| | "Randy" wrote in message
| | ...
| | | How do I change the value of a linked cell when using toggle
button or
| | check
| | | box I am using Excel 2003
| |
| |
| |
|
|
|