There are two kinds of option buttons that you can put on a worksheet, ActiveX options buttons and Forms toolbar option buttons. The technique to group them so that certain option buttons act as a unit is different depending on the type used.
Option buttons from the Control Toolbox have a GroupName property which determines which of the option buttons work as a group. When you add an option button, the GroupName property is set to the worksheet’s name. This means that all option buttons added to a worksheet will work as one unit if you don’t change the GroupName. Note that the GroupName property is set to the worksheet’s name at the time the control is added. If you change the worksheet’s name in between adding option buttons, they will have different GroupName properties. In the example below, option buttons 1 and 2 have the GroupName “Group1? and option buttons 3 and 4 have the GroupName “Group2?. I just made those GroupNames up, there’s really nothing special about them. That means that you can use any GroupName that you want, as long as you know that matching GroupName’s act as one group – even when the abscence of a GroupName matches.
To group option buttons from the Forms Toolbar, you have to place them in a GroupBox, also found on the Forms Toolbar. All option buttons in a GroupBox will act as one unit, and all option buttons outside of any GroupBox will act as one unit. In the example below, option buttons 7 and 8 are in one GroupBox and option buttons 9 and 10 are in another, which allows each pair to work independently of each other. Changing the CellLink of the option button will change the CellLink for every option button in that group.