View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Toggle Form Button Copied

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