Often OptionButton controls are arranged in control arrays. To quickly find the index of the only selected OptionButton control you can use the following code:

' assumes that the control array contains three OptionButton controlsintSelected = Option(0).Value * 0 - Option(1).Value * 1 - Option(2).Value * 2

Note that the first operand is always zero, and you can simplify the above expression as follows:

intSelected = -Option(1).Value - Option(2).Value * 2