Linking a cell to a toggle switch

[Brisbane Rob]

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

[Andrew]

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" <[email protected]>
wrote in message
news:[email protected]...
|
| 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
|

[Brisbane Rob]

Andrew

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

Thanks for your help