Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I divorce a pair of toggle buttons from the source I copied them from?
I made a yes toggle, copied it to make a no. I set them = to G3. The originals are called "option button 1" and "option button 2". When I copy them, I rename the new 2 buttons, "option button 3" and "option button 4" and set them = to another cell (G4). But when I click any of the 4 buttons I just created, it deselects all but the last one. How do I make it so the selection toggles between just one pair? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons. And then rightclick on an optionbutton on that group, choose Format Control|control tab. Then assign the linked cell. If you use optionbuttons from the control toolbox toolbar, rightclick on each of the members of the group, choose properties, and give that group a unique groupname. You can assign the Linkedcell on that properties window. TKS_Mark wrote: How do I divorce a pair of toggle buttons from the source I copied them from? I made a yes toggle, copied it to make a no. I set them = to G3. The originals are called "option button 1" and "option button 2". When I copy them, I rename the new 2 buttons, "option button 3" and "option button 4" and set them = to another cell (G4). But when I click any of the 4 buttons I just created, it deselects all but the last one. How do I make it so the selection toggles between just one pair? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to Use 1 Button to toggle On or Off | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Worksheet Functions | |||
Toggle Button | Excel Discussion (Misc queries) | |||
Toggle button | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Discussion (Misc queries) |