Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Linking a cell to a toggle switch


Excel Help suggests you can link a cell to a toggle switch from th
forms menu, but I can't work out how (the radio button has the facilit
in 'Properties'). Any one have any ideas?

Thank

--
Brisbane Ro
-----------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...fo&userid=2509
View this thread: http://www.excelforum.com/showthread.php?threadid=48023

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Linking a cell to a toggle switch

In the properties for the Toggle Button, type the cell ref you want it
linked to..This also works for Radio buttons & checkboxes.

HTH
Andrew

"Brisbane Rob"
wrote in message
news:Brisbane.Rob.1xmoue_1130529912.8689@excelforu m-nospam.com...
|
| Excel Help suggests you can link a cell to a toggle switch from the
| forms menu, but I can't work out how (the radio button has the facility
| in 'Properties'). Any one have any ideas?
|
| Thanks
|
|
| --
| Brisbane Rob
| ------------------------------------------------------------------------
| Brisbane Rob's Profile:
http://www.excelforum.com/member.php...o&userid=25096
| View this thread: http://www.excelforum.com/showthread...hreadid=480231
|


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Linking a cell to a toggle switch


Andrew

Thanks for your help. I'm obviously missing the point because I assum
that you've got to write some code to go with the button. If I want i
to put a value in the linked cell, how do I do that?

Thanks for your hel

--
Brisbane Ro
-----------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...fo&userid=2509
View this thread: http://www.excelforum.com/showthread.php?threadid=48023

Reply
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
Toggle cell value Ken G. Excel Discussion (Misc queries) 9 April 9th 23 12:48 PM
Toggle switch between absolute and relative values creating a macr Al Excel Discussion (Misc queries) 4 September 29th 05 08:15 PM
Toggle on/off switch for x-y graph Brad Charts and Charting in Excel 4 August 19th 05 03:08 AM
how to quickly toggle or switch to next worksheet Kwong Yau Leung Excel Worksheet Functions 3 May 9th 05 10:33 AM
Toggle a cell Brad K. Excel Programming 5 December 28th 04 07:58 AM


All times are GMT +1. The time now is 09:00 PM.

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

About Us

"It's about Microsoft Excel"