Toggle Button

How can i get the following code to only allow one toggle button to output true. Ie, i click ToggleButton1 and 2,3 go false. When Togglebutton2 is pressed, 1,3 go false. Currently the code just runs through the hole script. This is in the worksheet, not a userform

Thanks

Please Login or Register  to view this content.

Maybe using "Option Buttons " would be more suitable, They only allow one button to be "True"

Option buttons are just to small...

I found the following to work correctly,

Each button calls the following:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

to reset the buttons:

Please Login or Register  to view this content.

I don't think you can do it with "ToggleButtons" because each time you set a button to False/True you activate the click event on the next "ToggleButton", as the "Click" event Runs the the code.
You could, however do it with "CommandButtons" and change the Caption to "False/True" and the Color to "Red/Green"