Toggle buttons, Check boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
It's "Linked Cell" in the Properties.

--
Jim
| 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
| > | > | 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.
 
What values do you want to see?

True, false, or null, are the only values that make sense to me.
 
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
| 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
| > | > | 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
| > | > | > | > | How do I change the value of a linked cell when using toggle
button or
| > | > check
| > | > | box I am using Excel 2003
| > | >
| > | >
| > | >
| >
| >
| >
 
Back
Top