admannj:

Theoretically, the way I would handle this would involve a macro (I'm not
sure you would want this approach).

May I suggest an alternative?
1. Instead of an 'Option Button' approach - use a combo box. The combo box
requires an 'Input Range' (right click on the combo box, Choose 'Format
Control', choose 'Control', and the put in an input range. The input range
should be (e.g. A1 to A4 if the cells A1 to A4 contain 'Left, Right, Top,
Bottom"). Then create another combo box using a different input range (e.g.
B1 to B2 if the cells B1 to B2 contain 'Large, Small')

Hope this helps.

"admannj" wrote:

I need help with the option button, please.

I have the following on my form I am creating in Excel:

Location: * Left * Right * Top * Bottom
Size: * Large * Small

(* indicats the option button)

Excel has all 6 options linked together. I want people who use my form to
select one "location" answer and one "size" answer. However, Excel is only
letting me select one of the 6 options.

Any help is greatly appreciated.