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

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
|

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