LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default Toggle buttons, Check boxes

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
| |
| |
| |
|
|
|


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check Boxes or Option Buttons Lynda Excel Discussion (Misc queries) 3 April 4th 08 02:15 PM
option buttons or check boxes meandmyindigo via OfficeKB.com New Users to Excel 2 August 7th 06 12:55 PM
Check Boxes / Option Buttons.... Darin Kramer Excel Programming 2 December 16th 04 01:01 PM
Check Boxes and Option Buttons newboy18 Excel Programming 18 June 27th 04 07:00 PM
Buttons or Check boxes to filter data? Derek[_6_] Excel Programming 1 January 23rd 04 07:09 PM


All times are GMT +1. The time now is 08:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"