Quickly find which OptionButton is selected

Quickly find which OptionButton is selected

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

This tip has been brought to you by Subzero Solutions, the creators of VB.IDE Macro Studio, the tool of choice for integrating with the Visual Basic IDE. Learn more at


Share the Post: