Linking only 2 option buttons???

[pingwin77]

So I have a worksheet with 30 rows in it. Each of these rows have 2 options to select. I want to do this with Option buttons but all 60 of the option buttons are linked for the entire sheet. Is there a way to only have 2 linked to each other?

I have attached a sample of what I am working on.

I am concerned with the check boxes in Columns H and J. I need each row to be able to chose A or B, not both and each row is independent of the other rows.

Thanks in advance for taking a look at this. Let me know if you have any questions.

[BergShorn]

I would use Marlett checkboxes (search the forum for examples, or Google for). They are on the same layer as the cells (they are cells), which avoids problems inherent with controls on the drawing layer, and you can implement whatever logic you like to make them behave as checkboxes or option buttons.

[Palmetto]

I agree with BergShorn on the use of Marlett Check boxes.
See attached.

You are NOT using option buttons in your worksheet, you have check box controls, which is the wrong type of control when you want users to make choice between selection. Check boxes are typically used for a "yes" or "no" , "on/off", choice.

Marlett check boxes are much cleaner and easier to use, IMO.

Please Login or Register  to view this content.