ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Creating Buttons using the Forms Tool bar. (https://www.excelbanter.com/excel-worksheet-functions/137763-creating-buttons-using-forms-tool-bar.html)

MK

Creating Buttons using the Forms Tool bar.
 
Looking for Help..

I want to create 4 buttons with the forms toolbar.

but,

I want the first two to toggle (when one is clicked "ON" the other clicks
"OFF")
I want the second two to toggle (when one is clicked "ON" the other clicks
"OFF")

Right now, all four seem to be related so that if you click one of the four
buttons "ON", the other 3 Click OFF (all four seem to have the same cell
reference in Format Control.

Can someone help?

Thanks!


Jim Cone

Creating Buttons using the Forms Tool bar.
 

Go back to the Forms toolbar and select the "Group Box" control.
Draw one around each set of two buttons.
That will isolate each set from the other - provided you are actually
referring to Option Buttons and not Buttons.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

..
Those buttons are either Option
"MK"
wrote in message
Looking for Help..
I want to create 4 buttons with the forms toolbar.
but,
I want the first two to toggle (when one is clicked "ON" the other clicks
"OFF")
I want the second two to toggle (when one is clicked "ON" the other clicks
"OFF")
Right now, all four seem to be related so that if you click one of the four
buttons "ON", the other 3 Click OFF (all four seem to have the same cell
reference in Format Control.
Can someone help?
Thanks!



All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com